array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29874670 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1510985"
+post_author: 1
+"ListingKey": "29874670"
+"ListingId": "NB141130"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T17:40:04Z"
+"RFModificationTimestamp": "2026-06-15T17:49:02Z"
+"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-15T17:32:39Z"
+"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 [
"RoomKey" => "1659974563"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141130"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.44Z"
]
1 => array:11 [
"RoomKey" => "1659974564"
"RoomType" => "Bedroom"
"ListingId" => "NB141130"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.44Z"
]
2 => array:11 [
"RoomKey" => "1659974565"
"RoomType" => "3pc Bathroom"
"ListingId" => "NB141130"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.44Z"
]
3 => array:11 [
"RoomKey" => "1659974566"
"RoomType" => "Foyer"
"ListingId" => "NB141130"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.44Z"
]
4 => array:11 [
"RoomKey" => "1659974567"
"RoomType" => "Living room"
"ListingId" => "NB141130"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.44Z"
]
5 => array:11 [
"RoomKey" => "1659974568"
"RoomType" => "Dining room"
"ListingId" => "NB141130"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.44Z"
]
6 => array:11 [
"RoomKey" => "1659974569"
"RoomType" => "Mud room"
"ListingId" => "NB141130"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.45Z"
]
7 => array:11 [
"RoomKey" => "1659974570"
"RoomType" => "Bedroom"
"ListingId" => "NB141130"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.45Z"
]
8 => array:11 [
"RoomKey" => "1659974571"
"RoomType" => "Kitchen"
"ListingId" => "NB141130"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29874670"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T17:32:39.45Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29874670_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/e26a38c1a385a334daad2faf7c3be095.webp"
"MediaSize" => 157685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-e26a38c1a385a334daad2faf7c3be095.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29874670_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/bd0e9918ed2448fa2e3fa37d1f26158a.webp"
"MediaSize" => 173916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-bd0e9918ed2448fa2e3fa37d1f26158a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29874670_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/c5b63b3fa5b83e4a04e826af321bf23c.webp"
"MediaSize" => 77007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-c5b63b3fa5b83e4a04e826af321bf23c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29874670_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/bd7f3e37644d7999f8f2432049908daa.webp"
"MediaSize" => 80538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-bd7f3e37644d7999f8f2432049908daa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29874670_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/90413c80f422526e304109fffc95a2a0.webp"
"MediaSize" => 74473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-90413c80f422526e304109fffc95a2a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29874670_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/76926e00480868636d4b5e6a2e942613.webp"
"MediaSize" => 69349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-76926e00480868636d4b5e6a2e942613.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29874670_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/d25ac95d8db6874ae4233abc2cba0137.webp"
"MediaSize" => 78046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-d25ac95d8db6874ae4233abc2cba0137.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29874670_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/6f52697d66dc9ebaa3dbb03d28198bc5.webp"
"MediaSize" => 68535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-6f52697d66dc9ebaa3dbb03d28198bc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29874670_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/f8b49580d4fd5199052e941aac63faeb.webp"
"MediaSize" => 78923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-f8b49580d4fd5199052e941aac63faeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29874670_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/e227d503a9ed18928e51d442483b1b29.webp"
"MediaSize" => 56853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-e227d503a9ed18928e51d442483b1b29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29874670_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/be13b290694f9e6c4f13b8fab9355284.webp"
"MediaSize" => 66324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-be13b290694f9e6c4f13b8fab9355284.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29874670_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/591db0d0c2dde451292e011f3b6a42d7.webp"
"MediaSize" => 56007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-591db0d0c2dde451292e011f3b6a42d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29874670_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/7c2b19fd1fe5eedbef2614ed6fed6544.webp"
"MediaSize" => 54337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-7c2b19fd1fe5eedbef2614ed6fed6544.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29874670_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/e82b959baa41f707a2eb59ab47778c6b.webp"
"MediaSize" => 59149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-e82b959baa41f707a2eb59ab47778c6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29874670_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/72278d386d80853c4f59aab863c2d2ba.webp"
"MediaSize" => 51913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-72278d386d80853c4f59aab863c2d2ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29874670_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/90434ea809f84fa004c5f2680f56ae6c.webp"
"MediaSize" => 51670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-90434ea809f84fa004c5f2680f56ae6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29874670_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/2419d4130ffece1f9235b1b904c5ec5d.webp"
"MediaSize" => 68391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-2419d4130ffece1f9235b1b904c5ec5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29874670_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/8daaab23a864c4ded52509135993fe19.webp"
"MediaSize" => 55893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-8daaab23a864c4ded52509135993fe19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29874670_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/35b0cf0952016f1322bcbd5d205d5fe9.webp"
"MediaSize" => 65689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-35b0cf0952016f1322bcbd5d205d5fe9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29874670_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/0df0392d61cde70c67c4b6a52d476cf2.webp"
"MediaSize" => 56228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-0df0392d61cde70c67c4b6a52d476cf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29874670_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/f342903928f3dc005682cc99bdc2ff6b.webp"
"MediaSize" => 62931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-f342903928f3dc005682cc99bdc2ff6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29874670_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/a03269043a5a3e9709ff3391032c5709.webp"
"MediaSize" => 49769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-a03269043a5a3e9709ff3391032c5709.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29874670_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/63ab4ed16459e2d7fefec8de1640d485.webp"
"MediaSize" => 129616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-63ab4ed16459e2d7fefec8de1640d485.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29874670_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/08842c3a8ad1ba65aa9ce72059d2a328.webp"
"MediaSize" => 109379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-08842c3a8ad1ba65aa9ce72059d2a328.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29874670_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/9e1c3e9e21d49c51a35f4102449b1e8b.webp"
"MediaSize" => 100076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-9e1c3e9e21d49c51a35f4102449b1e8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29874670_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/d682853e989bb0bf257f728710bffbb2.webp"
"MediaSize" => 96930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-d682853e989bb0bf257f728710bffbb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29874670_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/d62a736a891555305f65c44450b71e26.webp"
"MediaSize" => 135911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-d62a736a891555305f65c44450b71e26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29874670_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/5764b028f53970a43d2e9885d0378283.webp"
"MediaSize" => 141048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-5764b028f53970a43d2e9885d0378283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29874670_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/6fab72656f75076a71ce791b72df0ab8.webp"
"MediaSize" => 147028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-6fab72656f75076a71ce791b72df0ab8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29874670_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/a40bdd25ab04528376f6e19966866bcd.webp"
"MediaSize" => 139957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-a40bdd25ab04528376f6e19966866bcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29874670_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/15114f8bb30a5d05410d2aebe3cd5d0d.webp"
"MediaSize" => 163951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-15114f8bb30a5d05410d2aebe3cd5d0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29874670_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/18905b08e8a7a25df135cc6cf9f60662.webp"
"MediaSize" => 137528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-18905b08e8a7a25df135cc6cf9f60662.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29874670_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/545fec914b3ac768c6178255a059c0d8.webp"
"MediaSize" => 144883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-545fec914b3ac768c6178255a059c0d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29874670_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/7c4b09d326a2d80eb35eb7d4de6e6591.webp"
"MediaSize" => 166077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-7c4b09d326a2d80eb35eb7d4de6e6591.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29874670_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/fb9bd71a7547b93cdc21906539f9762d.webp"
"MediaSize" => 171408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-fb9bd71a7547b93cdc21906539f9762d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29874670_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/7a5f28e3de6f818a188ce4c73d793a1b.webp"
"MediaSize" => 180770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-7a5f28e3de6f818a188ce4c73d793a1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29874670_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/88cd704698900356515059115d183301.webp"
"MediaSize" => 183780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-88cd704698900356515059115d183301.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29874670_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/4a8052d8a644a3649f22051d92939e73.webp"
"MediaSize" => 122116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-4a8052d8a644a3649f22051d92939e73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29874670_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/a9ec453c06783a33ef9baae694a0239b.webp"
"MediaSize" => 188627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-a9ec453c06783a33ef9baae694a0239b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29874670_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/cddb779534b6dacf019c5b72fd75313d.webp"
"MediaSize" => 186258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-cddb779534b6dacf019c5b72fd75313d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29874670_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/4bb69ee8b6d1a05c78a82191ee67e358.webp"
"MediaSize" => 191162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-4bb69ee8b6d1a05c78a82191ee67e358.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29874670_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/3d665ff5d4ddecc212e71c4d715a2aac.webp"
"MediaSize" => 185336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-3d665ff5d4ddecc212e71c4d715a2aac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29874670_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/be46bbe3ee2ba66a50c295996a21d4c5.webp"
"MediaSize" => 159219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-be46bbe3ee2ba66a50c295996a21d4c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29874670_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/79275474f16304decfbb4d1aefe95f21.webp"
"MediaSize" => 132928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-79275474f16304decfbb4d1aefe95f21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29874670_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29874670/a08ac802cf7b5d21493b2e5b15a3fa35.webp"
"MediaSize" => 132853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29874670/thumbnail-a08ac802cf7b5d21493b2e5b15a3fa35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141130"
"ResourceRecordKey" => "29874670"
"ModificationTimestamp" => "2026-06-09T12:28:44.55Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874670')"
+"ID": "1510985"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283841" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24781
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2151159" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24866
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29874670'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25188
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29874670'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25207
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31429865"
+"ListingKey": "29874670"
+"ListingId": "NB141130"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T12:00:00Z"
+"OpenHouseEndTime": "2026-06-13T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T16:40:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31429865')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31429864"
+"ListingKey": "29874670"
+"ListingId": "NB141130"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T16:40:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31429864')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31466919"
+"ListingKey": "29874670"
+"ListingId": "NB141130"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T15:26:51Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31466919')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29874670' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-66.65551 45.957887)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25283
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1540251"
+post_author: 1
+"ListingKey": "29917802"
+"ListingId": "NB141995"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:35:03Z"
+"RFModificationTimestamp": "2026-06-17T21:37:37Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 613.0
+"LivingArea": 1545.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B3Z9"
+"UnparsedAddress": "638 Hanson Street, Fredericton, New Brunswick E3B3Z9"
+"Coordinates": array:2 [
0 => -66.645894
1 => 45.949779
]
+"Latitude": 45.949779
+"Longitude": -66.645894
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this charming 1.5-storey home, ideally located on the hill within walking distance to the universities and close to many everyday amenities. Well cared for and move-in ready, this property offers a practical layout, tasteful updates, and a lovely backyard setting. The main level features an eat-in kitchen, spacious living room, good-sized bedroom, full bathroom, and rear sunporch that adds extra usable space and character. Updated laminate flooring runs through most rooms, giving the home a fresh, cohesive feel, while the bathroom has also been updated for added comfort and appeal. Upstairs offers two additional good-sized bedrooms, making this a great option for families, students, or anyone needing flexible space. The finished lower level provides even more living area with a large family room, fourth bedroom, and laundry room. Outside, enjoy a paved driveway, storage shed, mature trees, and a beautiful green backyard space perfect for relaxing, gardening, or enjoying some privacy in the heart of the city. Notable updates include a ductless heat pump, windows, metal roof, laminate flooring, and bathroom improvements. (id:62650)"
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-17T20:30:29.683645+00:00"
+"Directions": "Regent Street to Kings College Road to Hanson Street, civic #638"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091660"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "613"
+"ParcelNumber": "1461110"
+"PhotosChangeTimestamp": "2026-06-17T19:13:25Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T21:30:03Z"
+"Stories": "1.5"
+"TaxAnnualAmount": "3146.03"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=b4AWnQgPt4U&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1661514037"
"RoomType" => "Storage"
"ListingId" => "NB141995"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.01Z"
]
1 => array:11 [
"RoomKey" => "1661514038"
"RoomType" => "Laundry room"
"ListingId" => "NB141995"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.01Z"
]
2 => array:11 [
"RoomKey" => "1661514039"
"RoomType" => "Office"
"ListingId" => "NB141995"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "21'2'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.01Z"
]
3 => array:11 [
"RoomKey" => "1661514040"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141995"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.01Z"
]
4 => array:11 [
"RoomKey" => "1661514041"
"RoomType" => "Bedroom"
"ListingId" => "NB141995"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.02Z"
]
5 => array:11 [
"RoomKey" => "1661514042"
"RoomType" => "Office"
"ListingId" => "NB141995"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.02Z"
]
6 => array:11 [
"RoomKey" => "1661514043"
"RoomType" => "Storage"
"ListingId" => "NB141995"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.02Z"
]
7 => array:11 [
"RoomKey" => "1661514044"
"RoomType" => "Office"
"ListingId" => "NB141995"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.02Z"
]
8 => array:11 [
"RoomKey" => "1661514045"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB141995"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.02Z"
]
9 => array:11 [
"RoomKey" => "1661514046"
"RoomType" => "Living room"
"ListingId" => "NB141995"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.02Z"
]
10 => array:11 [
"RoomKey" => "1661514047"
"RoomType" => "Kitchen"
"ListingId" => "NB141995"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917802"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:30:03.02Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29917802/638-hanson-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1045
+"OriginalEntryTimestamp": "2026-06-17T19:13:25.62Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1364229"
+"ListOfficeNationalAssociationId": "1094072"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29917802_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/6627d67d8908bfa42082d5ea27e5fdec.webp"
"MediaSize" => 249327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-6627d67d8908bfa42082d5ea27e5fdec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29917802_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/8a3fa64237dfc84328b2f53ce14f0ca4.webp"
"MediaSize" => 251170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-8a3fa64237dfc84328b2f53ce14f0ca4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29917802_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/79a7c7db820ea2e01cf8b20415398ee7.webp"
"MediaSize" => 229361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-79a7c7db820ea2e01cf8b20415398ee7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29917802_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/0eee050c91e6abd83a495f20183911cf.webp"
"MediaSize" => 236738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-0eee050c91e6abd83a495f20183911cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29917802_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/8e281dbb28a790c1527bcff1cd431909.webp"
"MediaSize" => 275656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-8e281dbb28a790c1527bcff1cd431909.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29917802_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/1ff1ebc038826df3a18c0fb1ba090eb1.webp"
"MediaSize" => 89293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-1ff1ebc038826df3a18c0fb1ba090eb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29917802_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/56084cb774a8f75d8df7ee6379f6f0e1.webp"
"MediaSize" => 100770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-56084cb774a8f75d8df7ee6379f6f0e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29917802_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/d7d5e3db46a7cb36a5362e809d514b85.webp"
"MediaSize" => 82096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-d7d5e3db46a7cb36a5362e809d514b85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29917802_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/b727fd87bc5a33c1afa30e1649fe0c31.webp"
"MediaSize" => 85592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-b727fd87bc5a33c1afa30e1649fe0c31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29917802_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/ac394b70f27baea5d380f1b6b43924a6.webp"
"MediaSize" => 53302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-ac394b70f27baea5d380f1b6b43924a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29917802_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/024d7a7461e43d2ce53ca36464f218ba.webp"
"MediaSize" => 75359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-024d7a7461e43d2ce53ca36464f218ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29917802_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/3fbc17872061c5e4a02258021188a422.webp"
"MediaSize" => 67858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-3fbc17872061c5e4a02258021188a422.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29917802_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/2ad4e34ec2f83d5dc45e3eba33930e8c.webp"
"MediaSize" => 74998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-2ad4e34ec2f83d5dc45e3eba33930e8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29917802_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/4663509a9042c3ea89d26c3ee624ae98.webp"
"MediaSize" => 74759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-4663509a9042c3ea89d26c3ee624ae98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29917802_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/895a09b0c4f9ab783b9797f97cf66a37.webp"
"MediaSize" => 72907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-895a09b0c4f9ab783b9797f97cf66a37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29917802_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917802/07edd358005f321eb36027f2e1274935.webp"
"MediaSize" => 82608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917802/thumbnail-07edd358005f321eb36027f2e1274935.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141995"
"ResourceRecordKey" => "29917802"
"ModificationTimestamp" => "2026-06-17T19:13:25.63Z"
]
16 => array:13 [
"Order" => 17
…12
]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917802')"
+"ID": "1540251"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1541522"
+post_author: 1
+"ListingKey": "29916742"
+"ListingId": "NB142141"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:20:16Z"
+"RFModificationTimestamp": "2026-06-17T18:22:04Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 613.0
+"LivingArea": 1845.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B1L2"
+"UnparsedAddress": "134 Charlotte Street, Fredericton, New Brunswick E3B1L2"
+"Coordinates": array:2 [
0 => -66.65246
1 => 45.961689
]
+"Latitude": 45.961689
+"Longitude": -66.65246
+"YearBuilt": 1875
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this charming downtown Fredericton home, where classic character meets thoughtful modern updates. Located in the heart of the city, this 3-bedroom, 1.5-bathroom home is perfect for anyone looking to enjoy the convenience of downtown living without sacrificing outdoor space, featuring an expansive fully fenced backyard ideal for entertaining, gardening, pets, or simply relaxing.The open-concept main level is designed with entertaining in mind, creating a bright and inviting space where family and friends can gather with ease. At the heart of the home, the spacious kitchen features a large island and flows seamlessly into the living and dining areas, making it ideal for hosting guests or enjoying everyday life. Recent updates throughout the home provide a fresh, move-in-ready feel, while the functional layout offers comfortable living spaces suited to modern living. Just minutes from local restaurants, shops, schools, parks, walking trails, and all the amenities Fredericton has to offer, this property presents a rare opportunity to enjoy the best of downtown living with the added bonus of exceptional outdoor space. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-17T17:53:08.474679+00:00"
+"Directions": "Smythe to Charlotte St. House will be on your right."
+"ExteriorFeatures": array:1 [
0 => "Wood shingles"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Linoleum"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101268"
+"ListOfficeKey": "52787"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "613"
+"ParcelNumber": "75286781"
+"PhotosChangeTimestamp": "2026-06-17T18:14:11Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T18:14:10Z"
+"TaxAnnualAmount": "4693.15"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=jJdVRmCTeYV"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29916742/134-charlotte-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2151142"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "52787"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1845
+"OriginalEntryTimestamp": "2026-06-17T17:22:34.68Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1371196"
+"ListOfficeNationalAssociationId": "1007091"
+"CoListAgentNationalAssociationId": "1401905"
+"CoListOfficeNationalAssociationId": "1007091"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916742')"
+"ID": "1541522"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1538206"
+post_author: 1
+"ListingKey": "29914460"
+"ListingId": "NB141825"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:40:09Z"
+"RFModificationTimestamp": "2026-06-17T13:42:35Z"
+"ListPrice": 329900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 557.0
+"LivingArea": 882.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B3V6"
+"UnparsedAddress": "711 Reid Street, Fredericton, New Brunswick E3B3V6"
+"Coordinates": array:2 [
0 => -66.650585
1 => 45.950113
]
+"Latitude": 45.950113
+"Longitude": -66.650585
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 711 Reid Street! Lovingly cared for and extensively updated, this home offers a blend of character, comfort, and efficiency. The main level features a bright living room, functional kitchen, a spacious primary bedroom, and a beautifully renovated bathroom. At the rear of the home, a private sunroom overlooks the backyard, creating the perfect space to relax and enjoy the outdoors. Since purchasing the home, the current owners have completed numerous upgrades, including replacing flooring throughout, a full bathroom renovation, replacement of three main level windows, installation of energy-efficient heat pumps, replacement of both rear exterior doors, a new kitchen cabinet installation, and removal of the chimney. Additional improvements include insulating the basement walls and attic spaces, along with extensive air sealing to improve comfort and energy efficiency. Upstairs offers two additional bedrooms with convenient storage tucked under the eaves. The unfinished basement offers plenty of storage space and future potential. Located just steps from the YMCA and within walking distance to universities, schools, shopping, parks, and downtown amenities, this move in ready home is an excellent opportunity for first-time buyers, investors, or anyone looking to enjoy the convenience of central Fredericton living. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-17T13:42:29.727057+00:00"
+"Directions": "York St to Albert take left go to Reid Past YMCA take right on Reid"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Forced air"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2131233"
+"ListOfficeKey": "283841"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "557"
+"ParcelNumber": "01463272"
+"PhotosChangeTimestamp": "2026-06-17T12:33:01Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T12:33:01Z"
+"Stories": "1.5"
+"TaxAnnualAmount": "3188.53"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Fd1MZENcHx3"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29914460/711-reid-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1914735"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283841"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 882
+"OriginalEntryTimestamp": "2026-06-17T12:33:01.12Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1383924"
+"ListOfficeNationalAssociationId": "1335718"
+"CoListAgentNationalAssociationId": "1224172"
+"CoListOfficeNationalAssociationId": "1335718"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914460')"
+"ID": "1538206"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1536386"
+post_author: 1
+"ListingKey": "29909701"
+"ListingId": "NB141784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:25:05Z"
+"RFModificationTimestamp": "2026-06-17T20:26:55Z"
+"ListPrice": 358000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 307.0
+"LivingArea": 1468.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B3P2"
+"UnparsedAddress": "251 York Street, Fredericton, New Brunswick E3B3P2"
+"Coordinates": array:2 [
0 => -66.646651
1 => 45.959218
]
+"Latitude": 45.959218
+"Longitude": -66.646651
+"YearBuilt": 1937
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "THIS COULD BE A 3 BEDROOM HOME BY ADDING ONE WINDOW IN THE OFFICE/DEN UPSTAIRS! This fully renovated downtown home offers a modern living experience with its elegantly designed two bedrooms, one bath, and an additional versatile office/den space that could be used as a bedroom. Situated in a prime downtown location, it boasts high-end finishes throughout, seamlessly blending style and functionality. The open-concept living and dining area features abundant natural light, creating an inviting atmosphere ideal for both relaxation and entertainment. The large kitchen is a chefs dream, bright and open, stainless steel appliances, subway tile backsplash, lots of counter space for prep and cooking. Back mudroom with half bath, leading out to your private backyard/deck area. Up the beautiful staircase to your large primary bedroom with double windows, large second bedroom, office/den that could be used as a third bedroom. Large full bath with walk in tiled shower and separate soaker tub. Washer and dryer located on this floor. Heat pump with electric back up furnace, natural gas for hot water. This property is conveniently located downtown close to grocery stores, the market, restaurants and schools. (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Air exchanger"
1 => "Heat Pump"
]
+"CreationDate": "2026-06-16T16:19:29.074838+00:00"
+"Directions": "Fredericton South to York St"
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"Flooring": array:1 [
0 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1779773"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "307"
+"ParcelNumber": "01448141"
+"PhotosChangeTimestamp": "2026-06-16T15:45:25Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T20:15:12Z"
+"Stories": "1.5"
+"TaxAnnualAmount": "3981.34"
+"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/29909701/251-york-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1468
+"OriginalEntryTimestamp": "2026-06-16T15:45:24.89Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1187594"
+"ListOfficeNationalAssociationId": "1094072"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909701')"
+"ID": "1536386"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+post_id: "1519983"
+post_author: 1
+"ListingKey": "29887344"
+"ListingId": "NB141588"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:50:01Z"
+"RFModificationTimestamp": "2026-06-17T12:51:19Z"
+"ListPrice": 479800.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 863.71
+"LivingArea": 2096.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B2C9"
+"UnparsedAddress": "180 Edinburgh Street, Fredericton, New Brunswick E3B2C9"
+"Coordinates": array:2 [
0 => -66.657736
1 => 45.953921
]
+"Latitude": 45.953921
+"Longitude": -66.657736
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Step into this beautifully transformed bungalow, perfectly blending modern luxury with everyday comfort. The welcoming, sun-drenched living room greets you with a cozy gas fireplace, setting a warm tone for the entire home. Flow seamlessly into the elegant dining area, where patio doors open to reveal your private backyard paradise. The brand-new chef's kitchen features sleek Corian countertops, a classic farmhouse sink, stainless steel appliances, a stylish brick backsplash, and subtle under-counter lighting. The main level also offers three generously sized bedrooms and a pristine, freshly updated bathroom featuring a timeless white-tiled surround. Two new energy-efficient heat pumps ensure perfect climate control year-round. The fully finished lower level doubles your living space. Entertain effortlessly in the expansive new family room, complete with a dedicated wet bar and fridge. This level also includes a spacious fourth bedroom, a proper home office, a second stunning bathroom with a white-tiled surround, and a clean, organized mechanical room with laundry facilities. Outdoor living shines on the massive, private lot surrounded by mature shade trees. Host gatherings on the new 20' x 16' pressure-treated deck, fully equipped with a permanent metal-roof gazebo and built-in patio lighting. (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-11T16:29:12.206875+00:00"
+"Directions": "Take Smythe Street to Edinburgh Street. House on right."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Stove"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2184570"
+"ListOfficeKey": "52796"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "863.71"
+"ParcelNumber": "01439702"
+"PhotosChangeTimestamp": "2026-06-11T12:10:07Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T12:44:03Z"
+"TaxAnnualAmount": "4132.73"
+"VirtualTourURLUnbranded": "https://youtu.be/yC_iAYV-uw8"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29887344/180-edinburgh-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1048
+"OriginalEntryTimestamp": "2026-06-11T12:10:07.37Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1434139"
+"ListOfficeNationalAssociationId": "1007101"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887344')"
+"ID": "1519983"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+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 [ …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/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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884642')"
+"ID": "1516026"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1514649"
+post_author: 1
+"ListingKey": "29882443"
+"ListingId": "NB141395"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T19:20:07Z"
+"RFModificationTimestamp": "2026-06-14T19:20:42Z"
+"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:62650)"
+"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-14T19:14:29Z"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882443')"
+"ID": "1514649"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1509378"
+post_author: 1
+"ListingKey": "29871637"
+"ListingId": "NB141366"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T21:20:03Z"
+"RFModificationTimestamp": "2026-06-10T21:39:28Z"
+"ListPrice": 319900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 613.0
+"LivingArea": 1250.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B3Z5"
+"UnparsedAddress": "666 Kitchen Street, Fredericton, New Brunswick E3B3Z5"
+"Coordinates": array:2 [
0 => -66.647252
1 => 45.949736
]
+"Latitude": 45.949736
+"Longitude": -66.647252
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Let's address the address. No matter what you call it, one thing's for sure; this is the kind of location that's always in demand. Set in Fredericton's convenient Hill neighbourhood, this 3-bedroom, 1-bath home is within walking distance of UNB, STU, and NBCC, making it an excellent option for first-time buyers, parents looking to invest in housing for university-aged children, or investors seeking a property with long-term appeal. Step inside and you'll find a spacious foyer with a large closet, a bright living room and eat-in kitchen filled with natural light, and a practical layout that places the primary bedroom and full bathroom on the main level, making everyday living simple and functional. Upstairs, two generously sized bedrooms with large windows provide comfortable space for family, roommates, guests, or a home office setup. The fully fenced massive backyard is a standout feature, offering mature trees, privacy, and plenty of room for children and pets to play. Downstairs, the dry unfinished basement provides laundry and excellent storage today, and future development potential tomorrow. A major upgrade came in November 2023 with the installation of a brand-new $15,000 fully ducted electric heat pump, providing efficient central heating and air conditioning throughout the home. Additional improvements over the years include updates to the roof shingles, electrical, windows, and more. With all new appliances included and a paved driveway already in place, much of the heavy lifting has already been done. A location that works, a layout and investment that makes sense...and an address that's unforgettable. (id:62650)"
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Heat Pump"
]
+"CreationDate": "2026-06-08T20:39:07.145379+00:00"
+"Directions": "Regent Street to Kings College to Kitchen"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933114"
+"ListOfficeKey": "52787"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "613"
+"ParcelNumber": "01462092"
+"PhotosChangeTimestamp": "2026-06-08T19:03:34Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T21:14:07Z"
+"Stories": "1.5"
+"TaxAnnualAmount": "3509.9"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29871637/666-kitchen-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1250
+"OriginalEntryTimestamp": "2026-06-08T19:01:07.5Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1233276"
+"ListOfficeNationalAssociationId": "1007091"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29871637')"
+"ID": "1509378"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1490308"
+post_author: 1
+"ListingKey": "29846972"
+"ListingId": "NB140983"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T19:00:13Z"
+"RFModificationTimestamp": "2026-06-17T19:06:49Z"
+"ListPrice": 524900.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. Please note: property taxes reflected of non-owner occupied rate and will adjust down for occupied buyer 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:62650)"
+"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-17T18:53:02Z"
+"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": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29846972')"
+"ID": "1490308"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 48
+after_key: ""
}
"RF Response Time" => "0.34 seconds"
]
]