array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29846972 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23338
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23340
+post_id: "1490308"
+post_author: 1
+"ListingKey": "29846972"
+"ListingId": "NB140983"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T16:50:16Z"
+"RFModificationTimestamp": "2026-06-03T17:14:26Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 906.0
+"LivingArea": 2161.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B3G6"
+"UnparsedAddress": "807 Smythe, Fredericton, New Brunswick E3B3G6"
+"Coordinates": array:2 [
0 => -66.66235
1 => 45.951539
]
+"Latitude": 45.951539
+"Longitude": -66.66235
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Ideally situated on Fredericton's sought-after southside, this beautifully updated two-storey home offers exceptional convenience just minutes from schools, universities, walking trails, O'Dell Park, shopping, and everyday amenities. Over the years, the property has undergone extensive renovations, including updated siding, windows, kitchen, bathrooms, and a new roof in 2022, providing peace of mind for years to come. Step inside through the practical mudroomperfect for organizing seasonal gear and outdoor essentials. A French door leads into the heart of the home, where porcelain tile flooring transitions into a stylishly renovated kitchen featuring stainless steel appliances, a tiled backsplash, soft-close cabinetry, and thoughtfully designed pull-out storage. The bright dining area is enhanced by a charming bay window and flows seamlessly into the inviting living room, both accented by beautiful hardwood flooring. A convenient half bath and access to the rear deck complete the main level, making it ideal for both everyday living and entertaining. Upstairs, you'll find three spacious bedrooms and a renovated full bathroom. A standout feature is the covered balcony, complete with privacy roller shades and a television hookupan ideal space to relax and unwind. The lower level presents so much versatility. Excellent mortgage-helper, inlaw suite or investment opportunity with a self-contained studio apartment on its own electrical meter. The apartment shares access to a laundry area and storage room while maintaining excellent separation from the main living space. Whether you're looking for a family home with modern updates or a property that offers additional income potential, this versatile southside residence is one you won't want to miss. (id:62783)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-03T17:14:19.376842+00:00"
+"Directions": "Drive up Smythe and open your eyes and you will see it"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1986675"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "906"
+"ParcelNumber": "01441245"
+"PhotosChangeTimestamp": "2026-06-03T16:43:34Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-03T16:43:34Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "8640.95"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1650793956"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "NB140983"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.78Z"
]
1 => array:11 [
"RoomKey" => "1650793957"
"RoomType" => "Laundry room"
"ListingId" => "NB140983"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.78Z"
]
2 => array:11 [
"RoomKey" => "1650793958"
"RoomType" => "Family room"
"ListingId" => "NB140983"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.78Z"
]
3 => array:11 [
"RoomKey" => "1650793959"
"RoomType" => "Storage"
"ListingId" => "NB140983"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.78Z"
]
4 => array:11 [
"RoomKey" => "1650793960"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB140983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.78Z"
]
5 => array:11 [
"RoomKey" => "1650793961"
"RoomType" => "Bedroom"
"ListingId" => "NB140983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
6 => array:11 [
"RoomKey" => "1650793962"
"RoomType" => "Bedroom"
"ListingId" => "NB140983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
7 => array:11 [
"RoomKey" => "1650793963"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB140983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
8 => array:11 [
"RoomKey" => "1650793964"
"RoomType" => "2pc Bathroom"
"ListingId" => "NB140983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 2'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
9 => array:11 [
"RoomKey" => "1650793965"
"RoomType" => "Dining room"
"ListingId" => "NB140983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
10 => array:11 [
"RoomKey" => "1650793966"
"RoomType" => "Mud room"
"ListingId" => "NB140983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
11 => array:11 [
"RoomKey" => "1650793967"
"RoomType" => "Living room"
"ListingId" => "NB140983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
12 => array:11 [
"RoomKey" => "1650793968"
"RoomType" => "Kitchen"
"ListingId" => "NB140983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
13 => array:11 [
"RoomKey" => "1650793969"
"RoomType" => "Foyer"
"ListingId" => "NB140983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29846972"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T16:43:34.79Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29846972_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/5f46c37578cb2090bd48d5d30f3f514b.webp"
"MediaSize" => 193304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-5f46c37578cb2090bd48d5d30f3f514b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29846972_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/bf324cc288e443d2391893cfb1d1f559.webp"
"MediaSize" => 164495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-bf324cc288e443d2391893cfb1d1f559.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29846972_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/704e8a25e89846de9d87111c5f5c1120.webp"
"MediaSize" => 179601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-704e8a25e89846de9d87111c5f5c1120.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29846972_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/55676cb1e1e518ba98b5d27c23dc4479.webp"
"MediaSize" => 81253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-55676cb1e1e518ba98b5d27c23dc4479.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29846972_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/d6b347e790de967f6f41a1f757e63bcd.webp"
"MediaSize" => 64674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-d6b347e790de967f6f41a1f757e63bcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29846972_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/4d8aa6b4f57c5dcb5cb4a996f6429b5f.webp"
"MediaSize" => 53916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-4d8aa6b4f57c5dcb5cb4a996f6429b5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29846972_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/61ef0f48732aa956178796be9fbd6d18.webp"
"MediaSize" => 56712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-61ef0f48732aa956178796be9fbd6d18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29846972_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/da74a8710192e70b7102890ef6f83b47.webp"
"MediaSize" => 81827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-da74a8710192e70b7102890ef6f83b47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29846972_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/bd5dcca24a1c1ccd979c93e0cad6a9f3.webp"
"MediaSize" => 64680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-bd5dcca24a1c1ccd979c93e0cad6a9f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29846972_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/72ebf9cfad16d8a9be2b9488340ff619.webp"
"MediaSize" => 74582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-72ebf9cfad16d8a9be2b9488340ff619.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29846972_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/9d556d4de90d0cb796a9db99e9cade36.webp"
"MediaSize" => 84796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-9d556d4de90d0cb796a9db99e9cade36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29846972_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/918e02bf46bab04b24e9f3dc30618567.webp"
"MediaSize" => 78522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-918e02bf46bab04b24e9f3dc30618567.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29846972_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/458c456e892fc2ddf4009d636afbb1a6.webp"
"MediaSize" => 70647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-458c456e892fc2ddf4009d636afbb1a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29846972_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/ac491679b3559edbb39b68f024a832bf.webp"
"MediaSize" => 74553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-ac491679b3559edbb39b68f024a832bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29846972_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/ef890a60e397ea67f4116e51b7fbf03d.webp"
"MediaSize" => 88995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-ef890a60e397ea67f4116e51b7fbf03d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29846972_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/bc0081f1e26c5d88a2b56d44daf3f0ab.webp"
"MediaSize" => 97029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-bc0081f1e26c5d88a2b56d44daf3f0ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29846972_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/e33f077fafdaa61b85cb5c40239d9657.webp"
"MediaSize" => 92514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-e33f077fafdaa61b85cb5c40239d9657.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29846972_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/e93eea90ac269df08a3961a5746c0397.webp"
"MediaSize" => 34096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-e93eea90ac269df08a3961a5746c0397.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29846972_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/b81fa8e35e19f2ff4eb868d2bb3369e8.webp"
"MediaSize" => 71976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-b81fa8e35e19f2ff4eb868d2bb3369e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29846972_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/857c37abe692b1cac55e0954f7e4ed3e.webp"
"MediaSize" => 36193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-857c37abe692b1cac55e0954f7e4ed3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29846972_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/a48cc5961bb9782554397379ece059e9.webp"
"MediaSize" => 60625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-a48cc5961bb9782554397379ece059e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29846972_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/2e66a20c8086879d611c43b5971c1e56.webp"
"MediaSize" => 63790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-2e66a20c8086879d611c43b5971c1e56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29846972_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/6e8536535a345c286b2e286b02189413.webp"
"MediaSize" => 61628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-6e8536535a345c286b2e286b02189413.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29846972_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/ec4fb32d3c92fbb576ab6dfcdafc0751.webp"
"MediaSize" => 64357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-ec4fb32d3c92fbb576ab6dfcdafc0751.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29846972_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/62c5f0a872e5545c0358d8e97ced9e42.webp"
"MediaSize" => 53477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-62c5f0a872e5545c0358d8e97ced9e42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29846972_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/48d74de80525d21efac3b9f123bbd762.webp"
"MediaSize" => 46617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-48d74de80525d21efac3b9f123bbd762.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29846972_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/455f52bf60c71ca60e0e7073729de7bc.webp"
"MediaSize" => 74884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-455f52bf60c71ca60e0e7073729de7bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29846972_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/85b558a8c5a13bccd7b5421561d7a5eb.webp"
"MediaSize" => 63415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-85b558a8c5a13bccd7b5421561d7a5eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29846972_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/c2d57ea86eec10c06b0ae2c43a529b3a.webp"
"MediaSize" => 64859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-c2d57ea86eec10c06b0ae2c43a529b3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29846972_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/dcd454a5b006495aa6b8bca5cfa1de47.webp"
"MediaSize" => 100155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-dcd454a5b006495aa6b8bca5cfa1de47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29846972_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/b41f45778beb9743b124e7b9b7d84e15.webp"
"MediaSize" => 67938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-b41f45778beb9743b124e7b9b7d84e15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29846972_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/753223696677f5f53bad2370df9b0568.webp"
"MediaSize" => 77729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-753223696677f5f53bad2370df9b0568.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29846972_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/daa1465497d542744c9bdd3ae49ba8b5.webp"
"MediaSize" => 58719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-daa1465497d542744c9bdd3ae49ba8b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29846972_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/07a22be339049b61a7268a14bc5b35ac.webp"
"MediaSize" => 63515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-07a22be339049b61a7268a14bc5b35ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29846972_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/ffd2ab1e6eb9bc88407fe81b5ade8c31.webp"
"MediaSize" => 52387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-ffd2ab1e6eb9bc88407fe81b5ade8c31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29846972_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/94c1073bb549412ff1478efdfabf5246.webp"
"MediaSize" => 67065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-94c1073bb549412ff1478efdfabf5246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29846972_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/68b6c5fdd70fb4559c9261a38e488a2b.webp"
"MediaSize" => 62074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-68b6c5fdd70fb4559c9261a38e488a2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29846972_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/d9cfe41952e1a781267107c5ff22159f.webp"
"MediaSize" => 159382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-d9cfe41952e1a781267107c5ff22159f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29846972_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/e92a9209af8523a7234ac3ec3fa11f18.webp"
"MediaSize" => 171216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-e92a9209af8523a7234ac3ec3fa11f18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29846972_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/b13be5994853a3fe6cd2062ac829c322.webp"
"MediaSize" => 151639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-b13be5994853a3fe6cd2062ac829c322.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29846972_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/6ea5da564b63edd06a3069e32cddbf1d.webp"
"MediaSize" => 165581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-6ea5da564b63edd06a3069e32cddbf1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29846972_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/321c0b5e6f4ce47d11f09b483928743f.webp"
"MediaSize" => 134939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-321c0b5e6f4ce47d11f09b483928743f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29846972_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/360d55cd3b36d11c61bfe7e9379f1979.webp"
"MediaSize" => 149604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-360d55cd3b36d11c61bfe7e9379f1979.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29846972_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/9cefcfa17befe711889e5b735ce6f207.webp"
"MediaSize" => 190127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-9cefcfa17befe711889e5b735ce6f207.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29846972_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/121617d59bde03d558bfb71cfcb5cfae.webp"
"MediaSize" => 183937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-121617d59bde03d558bfb71cfcb5cfae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29846972_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29846972/4f8b7fb7f3c9e2e2b6921085e85d0040.webp"
"MediaSize" => 160715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29846972/thumbnail-4f8b7fb7f3c9e2e2b6921085e85d0040.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140983"
"ResourceRecordKey" => "29846972"
"ModificationTimestamp" => "2026-06-03T16:43:34.75Z"
]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29846972')"
+"ID": "1490308"
}
]
+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 289196" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24716
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1986675" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24752
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29846972'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25124
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29846972'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25140
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29846972' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-66.66235 45.951539)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25224
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: 1514649
+post_author: 1
+"ListingKey": "29882443"
+"ListingId": "NB141395"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T16:20:11Z"
+"RFModificationTimestamp": "2026-06-10T16:36:33Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1119.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B9K7"
+"UnparsedAddress": "158 Hanwell Road Unit# 309, Fredericton, New Brunswick E3B9K7"
+"Coordinates": array:2 [
0 => -66.668724
1 => 45.960085
]
+"Latitude": 45.960085
+"Longitude": -66.668724
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to Sunshine Terrace, ideally located in Fredericton's highly sought-after Sunshine Gardens neighbourhood. This rare 2-bedroom, 2-bathroom corner unit offers over 1,100 sq. ft. of bright, thoughtfully designed living space and is one of only a few units in the building featuring this desirable layout. Constructed with solid concrete, the building provides exceptional soundproofing and energy efficiency for comfortable, low-maintenance living year-round. The open-concept design is perfect for both everyday living and entertaining. The spacious kitchen features an abundance of cabinetry and storage, ample counter space, and a full-size island with breakfast bar seating, all overlooking the dining and living areas. The sun-filled living room offers patio door access to a private balcony, while a walk-in pantry/storage room off the front foyer provides additional convenience and functionality. The primary bedroom features a double closet and private ensuite bath. The second bedroom is generously sized, also offering a double closet and easy access to the main bathroom. As a third-floor corner unit, the condo benefits from additional windows and an abundance of natural light throughout. Located directly across from Odell Park and its 400+ acres of walking trails and green space, this property offers the perfect blend of nature and convenience. Shopping, dining, recreation facilities, universities, and downtown Fredericton are all just minutes away. Residents also enjoy a secure elevator building, an exclusive parking space, and a community room. A rare opportunity to own a spacious, bright, and well-located condo in one of Fredericton's most desirable areas. Book your private showing today. (id:62783)"
+"AssociationFee": "465"
+"AssociationFeeFrequency": "Monthly"
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-10T16:36:15.756893+00:00"
+"Directions": "Hanwell road to #158 (Corner of Hanwell Road and Waggoner's Lane) Can access driveway on Hanwell or Waggoner's Lane."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1873924"
+"ListOfficeKey": "270874"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Level lot"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "75433722"
+"PhotosChangeTimestamp": "2026-06-10T16:14:54Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T16:14:53Z"
+"TaxAnnualAmount": "3173.92"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=M79D5MEsD5A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1656319007"
"RoomType" => "3pc Ensuite bath"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.92Z"
]
1 => array:11 [
"RoomKey" => "1656319008"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.92Z"
]
2 => array:11 [
"RoomKey" => "1656319009"
"RoomType" => "Bedroom"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.93Z"
]
3 => array:11 [
"RoomKey" => "1656319010"
"RoomType" => "3pc Bathroom"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 5'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.93Z"
]
4 => array:11 [
"RoomKey" => "1656319011"
"RoomType" => "Dining room"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.93Z"
]
5 => array:11 [
"RoomKey" => "1656319012"
"RoomType" => "Living room"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "16'6'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.93Z"
]
6 => array:11 [
"RoomKey" => "1656319013"
"RoomType" => "Pantry"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.93Z"
]
7 => array:11 [
"RoomKey" => "1656319014"
"RoomType" => "Kitchen"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.93Z"
]
8 => array:11 [
"RoomKey" => "1656319015"
"RoomType" => "Foyer"
"ListingId" => "NB141395"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882443"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T16:14:53.93Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29882443_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/e63c047337b2eb34425279fd44e2b98d.webp"
"MediaSize" => 107790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-e63c047337b2eb34425279fd44e2b98d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29882443_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/60594ba6a96303e898b941061f02f871.webp"
"MediaSize" => 111046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-60594ba6a96303e898b941061f02f871.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29882443_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/231753c655c0805dbb970b23eee70212.webp"
"MediaSize" => 142348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-231753c655c0805dbb970b23eee70212.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29882443_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/f37af76bc4a832d8e655400232b6352b.webp"
"MediaSize" => 156323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-f37af76bc4a832d8e655400232b6352b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29882443_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/d52bf662cf23d4ec6413ecf1d9b8c337.webp"
"MediaSize" => 80597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-d52bf662cf23d4ec6413ecf1d9b8c337.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29882443_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/a7b4bf5d2c272a1b655e97d3694ad10a.webp"
"MediaSize" => 78562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-a7b4bf5d2c272a1b655e97d3694ad10a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29882443_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/d27bad15970a39599700dbddd0a0e599.webp"
"MediaSize" => 77986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-d27bad15970a39599700dbddd0a0e599.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29882443_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/7edcc86ebbfe228074788b6d906109a7.webp"
"MediaSize" => 77322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-7edcc86ebbfe228074788b6d906109a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29882443_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/a5c71b016e656350b10c97a602e37c90.webp"
"MediaSize" => 58427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-a5c71b016e656350b10c97a602e37c90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29882443_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/1b212eceeb89186df3ef024cf0139a0b.webp"
"MediaSize" => 94008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-1b212eceeb89186df3ef024cf0139a0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141395"
"ResourceRecordKey" => "29882443"
"ModificationTimestamp" => "2026-06-10T16:14:53.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29882443_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882443/0de41fc9f21c82a18669871624bb96ef.webp"
"MediaSize" => 81094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882443/thumbnail-0de41fc9f21c82a18669871624bb96ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882443')"
+"ID": 1514649
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1510985"
+post_author: 1
+"ListingKey": "29874670"
+"ListingId": "NB141130"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T12:35:35Z"
+"RFModificationTimestamp": "2026-06-09T17:45:21Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 766.0
+"LivingArea": 1089.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B1W1"
+"UnparsedAddress": "138 Victoria Street, Fredericton, New Brunswick E3B1W1"
+"Coordinates": array:2 [
0 => -66.65551
1 => 45.957887
]
+"Latitude": 45.957887
+"Longitude": -66.65551
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this charming and well-maintained 3-bedroom home, ideally situated in one of downtown's most convenient and sought-after neighbourhoods. Just steps from Superstore, Wilmot Park, walking trails, schools, shopping, and a wide range of amenities, this property offers an exceptional lifestyle with everything you need close at hand. Inside, you'll find bright and inviting living spaces that blend comfort and character. The thoughtfully updated bathroom features modern finishes while complementing the home's timeless appeal. Whether you're relaxing with family or entertaining guests, the functional layout provides a warm and welcoming atmosphere throughout. A standout feature of this property is the oversized backyardan increasingly rare offering in the downtown core. With ample space for gardening, outdoor entertaining, children's play areas, or simply enjoying the outdoors, this expansive lot provides endless opportunities to suit your lifestyle. Perfect for first-time home buyers, downsizers, or anyone seeking the convenience of downtown living combined with exceptional outdoor space, this property presents a unique opportunity in a highly desirable location. (id:62783)"
+"Cooling": array:1 [
0 => "Air Conditioned"
]
+"CreationDate": "2026-06-09T17:43:55.636603+00:00"
+"Directions": "Smythe to Victoria, house on right."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2151159"
+"ListOfficeKey": "283841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "766"
+"ParcelNumber": "01442292"
+"PhotosChangeTimestamp": "2026-06-09T12:28:44Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-09T12:28:44Z"
+"Stories": "1.5"
+"TaxAnnualAmount": "3296.1"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LxihBgBevKj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29874670/138-victoria-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2195141"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283841"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1089
+"OriginalEntryTimestamp": "2026-06-09T12:28:44.54Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1401951"
+"ListOfficeNationalAssociationId": "1335718"
+"CoListAgentNationalAssociationId": "1443762"
+"CoListOfficeNationalAssociationId": "1335718"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874670')"
+"ID": "1510985"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1509378"
+post_author: 1
+"ListingKey": "29871637"
+"ListingId": "NB141366"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T12:00:57Z"
+"RFModificationTimestamp": "2026-06-09T12:01:26Z"
+"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:62783)"
+"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-09T11:50:11Z"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29871637')"
+"ID": "1509378"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1484261"
+post_author: 1
+"ListingKey": "29839692"
+"ListingId": "NB140531"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T23:36:10Z"
+"RFModificationTimestamp": "2026-06-07T23:44:45Z"
+"ListPrice": 579900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 680.0
+"LivingArea": 2335.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B3S7"
+"UnparsedAddress": "683 Mitchell Street, Fredericton, New Brunswick E3B3S7"
+"Coordinates": array:2 [
0 => -66.651996
1 => 45.951327
]
+"Latitude": 45.951327
+"Longitude": -66.651996
+"YearBuilt": 1953
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "INVESTMENT OPPORTUNITY in Fredericton's highly desirable Hill area! Welcome to 683 Mitchell Street, a turnkey two-unit property ideally located within walking distance to UNB, STU, the Dr. Everett Chalmers Hospital, the YMCA, and just minutes from downtown Fredericton and all amenities. Whether you're looking to expand your investment portfolio, owner-occupy while generating rental income, or purchase your first income property, this one is worth a closer look. Full of charm, character, and natural light, this well-maintained property features two self-contained units (one meter), separate laundry for each unit, and numerous upgrades already completed. The unique layout includes a dedicated top-floor primary retreat, adding even more appeal and functionality. The property benefits from strong rental appeal thanks to its proximity to universities, healthcare, recreation, shopping, and city trails. Outside, you'll find a large deck overlooking a good-sized backyard, providing plenty of space to relax, entertain, or enjoy the outdoors. A garage and ample storage throughout the property add even more convenience and functionality for owners and tenants alike. As an added bonus, much of the home's contentsincluding furnishings, décor, artwork, kitchenware, bedding, towels, and morecan be negotiated as part of an offer, creating a truly turnkey opportunity for the next owner. Additional updates include a new roof installed in 2021, offering added peace of mind for years to come. Income properties in locations like this are hard to come by. Whether you're seeking a strong investment, a mortgage helper, or a property with flexibility for future use, 683 Mitchell Street offers exceptional value in one of Fredericton's most sought-after neighbourhoods. All measurements are to be verified by the purchaser. (id:62783)"
+"BathroomsPartial": 1
+"CreationDate": "2026-06-02T17:00:39.340941+00:00"
+"Directions": "Regent St N, left on Kings College Rd, Right on Mitchell St."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:4 [
0 => "Laminate"
1 => "Ceramic"
2 => "Vinyl"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2132565"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "680"
+"ParcelNumber": "01450915"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T16:01:07Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-07T23:28:26Z"
+"Stories": "1.5"
+"TaxAnnualAmount": "7268.63"
+"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/29839692/683-mitchell-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1342
+"OriginalEntryTimestamp": "2026-06-02T16:00:10.16Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1385207"
+"ListOfficeNationalAssociationId": "1375426"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839692')"
+"ID": "1484261"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1487351"
+post_author: 1
+"ListingKey": "29838439"
+"ListingId": "NB140875"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T13:51:04Z"
+"RFModificationTimestamp": "2026-06-02T14:08:34Z"
+"ListPrice": 674900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 1424.0
+"LivingArea": 2700.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B5M2"
+"UnparsedAddress": "79 Colonial Heights Street, Fredericton, New Brunswick E3B5M2"
+"Coordinates": array:2 [
0 => -66.677739
1 => 45.960288
]
+"Latitude": 45.960288
+"Longitude": -66.677739
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "You really have to visit this home to appreciate the quality of the renovation, the absolutely beautiful property and the lifestyle this home provides. Located in one of Frederictons most desirable neighbourhoods near the golf course and in the Garden Creek School zone, this large bungalow with garage offers almost 3000 square feet of living space. The main floor was completely renovated a few years ago, offering beautiful wide hardwood, all new windows, and a modern aesthetic. Enter into the mudroom and then the huge livingroom which offers two seating areas, a working wood fireplace, and gorgeous front window. The kitchen is modern and features quartz counters, a walk-in pantry, dining area and an amazing orange Bertazzoni stove. The extension at the back of the home provides access to the deck and private backyard. You'll enjoy the newly installed hottub, two tier deck and firepit area while listening to 'Phyllis' -the babbling brook at the back of the property! The main floor also offers two lovely bedrooms with the primary offering a two piece ensuite and another beautiful bathroom. The lower level offers two more large bedrooms with egress windows, a 3rd bathroom, laundry and yet another familyroom. A ducted heat pump offers year round comfort. This home is a truly rare find. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-02T14:08:23.736937+00:00"
+"Directions": "Golf club rd... left on to Colonial Heights St... 79 is on the right."
+"ExteriorFeatures": array:1 [
0 => "Colour Loc"
]
+"Flooring": array:4 [
0 => "Laminate"
1 => "Ceramic"
2 => "Linoleum"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
3 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1471504"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Golf course/parkland"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1424"
+"ParcelNumber": "01478254"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T13:15:31Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-02T13:44:28Z"
+"TaxAnnualAmount": "6127.39"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=XHVHsjpgV9a"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …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/29838439/79-colonial-heights-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2026-06-02T13:15:30.77Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1128041"
+"ListOfficeNationalAssociationId": "1375426"
+"Media": array:38 [
0 => array:13 [ …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": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29838439')"
+"ID": "1487351"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: "1480739"
+post_author: 1
+"ListingKey": "29834689"
+"ListingId": "NB140760"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T22:20:17Z"
+"RFModificationTimestamp": "2026-06-02T22:24:17Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 1285.0
+"LivingArea": 1827.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B2S4"
+"UnparsedAddress": "10 Shamrock Terrace, Fredericton, New Brunswick E3B2S4"
+"Coordinates": array:2 [
0 => -66.661438
1 => 45.954251
]
+"Latitude": 45.954251
+"Longitude": -66.661438
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "There's ""The Hill"", and then there's the terraces. Some neighbourhoods in Fredericton have a reputation for a reason. And homes beside ODell Park are one of them!10 Shamrock Terrace sits perched at the end of a quiet court directly beside O'Dell. A lifestyle location where you can finish work and be walking through the woods (or teeing off at your favourite course!) five minutes later. Where downtown dinners, Boyce Farmers Market mornings, grocery runs, schools, universities & nature trails all exist within the same small radius of your life. And where despite being this connected...it still feels as peaceful as the country. The home has already gone through extensive updates over the years, apparent immediately from the composite front deck entry & mudroom addition.The space inside feels warm, functional, and well thought out, with a level of efficiency that makes every square foot count. Natural light pours through the main level, while the living rooms wood-burning fireplace heats the whole space. Kitchen is ergonomically planned and connects the spaces beautifully between the oversized dining room & living rooms. Three bedrooms & full bath complete the upper level, while downstairs gives you the flexibility of a 4th bedroom, oversized family/games room, half bath & storage. Outside, the pie-shaped lot has been meticulously maintained w/ mature landscaping, manicured lawns, detached garage, workshop & paved driveway. You won't know you're in the city when you sit on your back patio, with nothing but mature trees and the sounds of birds chirping surrounding you. Tons of upgrades throughout but truthfully, if you ask the current owners what theyll miss most, its not a feature inside the house. Its the proximity, the park and the lifestyle that comes with it. Locals wait for a home on ""The Terraces'. And once you live here, youll understand exactly why. (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Heat Pump"
1 => "Air Conditioned"
]
+"CreationDate": "2026-06-01T19:30:30.307101+00:00"
+"Directions": "The terraces backing onto Odell! Smythe Street from the Superstore, right onto Shamrock, #10 is the last home at the very top of the court"
+"ExteriorFeatures": array:2 [
0 => "Vinyl"
1 => "Other"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:6 [
0 => "Heat Pump"
1 => "Stove"
2 => "Electric"
3 => "Natural gas"
4 => "Wood"
5 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933114"
+"ListOfficeKey": "52787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1285"
+"ParcelNumber": "01441062"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T18:43:20Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-02T22:14:39Z"
+"TaxAnnualAmount": "4701.12"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29834689/10-shamrock-terrace-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1237
+"OriginalEntryTimestamp": "2026-06-01T18:43:20.08Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1233276"
+"ListOfficeNationalAssociationId": "1007091"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29834689')"
+"ID": "1480739"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23352
+post_id: "1480741"
+post_author: 1
+"ListingKey": "29831567"
+"ListingId": "NB140677"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T22:20:58Z"
+"RFModificationTimestamp": "2026-06-04T22:36:00Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 854.0
+"LivingArea": 1581.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B3A6"
+"UnparsedAddress": "295 Willingdon Street, Fredericton, New Brunswick E3B3A6"
+"Coordinates": array:2 [
0 => -66.661227
1 => 45.945728
]
+"Latitude": 45.945728
+"Longitude": -66.661227
+"YearBuilt": 1968
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "On the hill! This well-maintained home offers an exceptional combination of style, convenience, and value. Situated on a private lot surrounded by mature trees, the property features a large deck, garage, and plenty of outdoor space for family activities and entertaining. The main level includes a sun-filled living room with an energy-efficient ductless heat pump, a spacious dining area with patio doors leading to the extra-large deck, and a lovely kitchen offering abundant cabinetry, prep space, and a tiered breakfast counter. Three bedrooms are located on this floor, all featuring double closets, including the primary bedroom with extra closet space. A full bathroom with tub/shower combination completes this level. Downstairs, you will find a large family room highlighted by warm knotty pine walls, a fourth bedroom (non-egress), a 2-piece bathroom, and a generous storage room with a laundry area. The garage offers ample room for a vehicle plus additional storage. Families will appreciate the proximity to Priestman Street Elementary School, Fredericton High School, and the neighbourhood playground and wading pool just a block away. UNB and STU are within walking distance, making this an excellent option for university students. Uptown amenities, shopping, restaurants, and services are all nearby. A fantastic opportunity in a prime location that shows pride of ownership throughout. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Heat Pump"
1 => "Air Conditioned"
]
+"CreationDate": "2026-06-01T13:58:48.166643+00:00"
+"Directions": "York Street to Massey to Willingdon Street, or Smythe Street to Willingdon Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl"
]
+"Flooring": array:4 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
3 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Electric"
2 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1435058"
+"ListOfficeKey": "270874"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Treed"
1 => "Golf course/parkland"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "854"
+"ParcelNumber": "01453497"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T13:41:00Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-04T22:14:42Z"
+"TaxAnnualAmount": "4799.39"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=wtQMrqELMys"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29831567/295-willingdon-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2173951"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "270874"
+"GeocodeManualYN": false
+"ZoningDescription": "R-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1179
+"OriginalEntryTimestamp": "2026-06-01T12:43:37.17Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1109402"
+"ListOfficeNationalAssociationId": "1237075"
+"CoListAgentNationalAssociationId": "1424284"
+"CoListOfficeNationalAssociationId": "1237075"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29831567')"
+"ID": "1480741"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25222
+post_id: "1474543"
+post_author: 1
+"ListingKey": "29823158"
+"ListingId": "NB140641"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T19:20:08Z"
+"RFModificationTimestamp": "2026-06-06T19:34:41Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 600.0
+"LivingArea": 2864.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0H2"
+"UnparsedAddress": "28 Lunney Street, Fredericton, New Brunswick E3G0H2"
+"Coordinates": array:2 [
0 => -66.64384
1 => 45.960733
]
+"Latitude": 45.960733
+"Longitude": -66.64384
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Move-in ready! This modern and practical split-entry home is located in the highly sought-after, family-friendly Brookside West neighborhood. Just minutes from West Hills Golf, Saint James Gate, Brookside Mall, and Killarney Lake, youll enjoy easy access to golf, fishing, swimming, biking, and hiking trails right at your doorstep. Designed with both style and function in mind, this home features stunning floor-to-ceiling custom kitchen cabinetry, a large walk-in pantry, and beautiful quartz countertops throughout. The open-concept layout is highlighted by 9-foot ceilings on both levels, gorgeous LVP flooring, hardwood stairs with black balusters, and a spacious island perfect for entertaining. Additional features include a modern steel roof ready for easy solar panel installation, an energy-efficient mini-split heat pump, a massive double-car garage, and a large private deck ideal for relaxing or hosting guests. The lower level offers excellent flexibility with a convenient kitchenette, creating great potential for rental income or comfortable extended family living. A perfect blend of modern design, efficiency, and location this home truly has the wow factor! (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Fishing"
]
+"Cooling": array:2 [
0 => "Air exchanger"
1 => "Heat Pump"
]
+"CreationDate": "2026-05-29T14:32:24.092210+00:00"
+"Directions": "Head Toward Killarney on Brookside Drive, Turn left on Heron, Left Donmac and the first Right on Lunney street."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Slab"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058872"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Golf course/parkland"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "600"
+"ParcelNumber": "75567875"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T13:20:58Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-06T19:13:22Z"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29823158/28-lunney-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2005765"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1986675"
+"CoListOfficeKey": "289196"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "289196"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2864
+"OriginalEntryTimestamp": "2026-05-29T13:15:24.92Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1334434"
+"ListOfficeNationalAssociationId": "1375426"
+"CoListAgentNationalAssociationId": "1288160"
+"CoListAgentNationalAssociationId2": "1271082"
+"CoListOfficeNationalAssociationId": "1375426"
+"CoListOfficeNationalAssociationId2": "1375426"
+"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": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29823158')"
+"ID": "1474543"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25223
+post_id: "1468252"
+post_author: 1
+"ListingKey": "29817053"
+"ListingId": "NB140481"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-29T14:01:10Z"
+"RFModificationTimestamp": "2026-05-29T14:06:25Z"
+"ListPrice": 415000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 1108.0
+"LivingArea": 1108.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B9T9"
+"UnparsedAddress": "1 Golf Greens Lane Unit# 317, Fredericton, New Brunswick E3B9T9"
+"Coordinates": array:2 [
0 => -66.680997
1 => 45.9556
]
+"Latitude": 45.9556
+"Longitude": -66.680997
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to Golf Greens Condominiums, where luxury meets leisure! This beautifully renovated 2-bedroom, 2-bath condo offers a bright and airy living space with stunning views of the Fredericton golf course from every bedroom, the living room, and the patio. As you enter the building, you're greeted by tastefully decorated common area setting with seating, creating a welcoming atmosphere. The convenience of an elevator makes accessing your unit effortless. Inside the condo, you'll find a spacious foyer that leads into the modern, open-concept design. The newly renovated kitchen offers gorgeous granite countertops and flows seamlessly into the dining and living areas, perfect for entertaining or relaxing after a long day. Step outside onto your private patio and soak in the serene golf course scenery, and enjoy your morning coffee or later afternoon cocktail. A wide variety of amenities, including underground parking, Library area, a well-equipped gym, barbecue area off the communal kitchen, additional inviting sitting areas, and a private storage locker. This property also has a back up generator to run the lights in the halls and the elevator. Don't miss the opportunity to own this exceptional condo in a prime location. (id:62650)"
+"AssociationFee": "317"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:2 [
0 => "Air exchanger"
1 => "Air Conditioned"
]
+"CreationDate": "2026-05-28T14:50:19.444128+00:00"
+"Directions": "Take Hanwell road and head down the hill to 1 Golf Greens Lane unit 317."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1638647"
+"ListOfficeKey": "258211"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Golf course/parkland"
1 => "Wheelchair access"
]
+"LotSizeDimensions": "1108"
+"ParcelNumber": "75392068"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Heated Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T15:01:20Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-29T13:52:37Z"
+"TaxAnnualAmount": "3345.23"
+"View": "River view"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ewkEk17xc6Y&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29817053/1-golf-greens-lane-unit-317-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2227646"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "2257227"
+"CoListOfficeKey": "258211"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "258211"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1108
+"OriginalEntryTimestamp": "2026-05-28T14:24:01.7Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1177438"
+"ListOfficeNationalAssociationId": "1243998"
+"CoListAgentNationalAssociationId": "1470502"
+"CoListAgentNationalAssociationId2": "1496053"
+"CoListOfficeNationalAssociationId": "1243998"
+"CoListOfficeNationalAssociationId2": "1243998"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29817053')"
+"ID": "1468252"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 47
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]