array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29905395 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1533856"
+post_author: 1
+"ListingKey": "29905395"
+"ListingId": "NB141961"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:50:07Z"
+"RFModificationTimestamp": "2026-06-15T19:12:54Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 13756.278
+"LivingArea": 1921.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G0B5"
+"UnparsedAddress": "76 Squire Drive, Quispamsis, New Brunswick E2G0B5"
+"Coordinates": array:2 [
0 => -65.958984
1 => 45.441876
]
+"Latitude": 45.441876
+"Longitude": -65.958984
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Brand new construction. This beauty offers spectacular views. This four bedroom, two and a half bathroom home comes with an eight-year Lux warranty, will be landscaped and comes with a six-thousand-dollar appliance package. Main level is an open concept with an awesome walk-in pantry, centre island and access to a fenced patio off the dining area, perfect for the barbecue and outside dining. Upstairs features the large primary bedroom complete with double vanity ensuite and walk in closet, three more generous bedrooms, the main bath, laundry room and common area for the family to gather or use as a T.V. area. There is access to the rear deck off this level as well. There is a built in two car garage. Book your private viewing before its gone! (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Contemporary"
1 => "2 Level"
]
+"Basement": array:3 [
0 => "None"
1 => "Not Applicable"
2 => "Slab"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-15T19:12:09.307892+00:00"
+"Directions": "Gondola Point Arterial to Squire Dr. to #76."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2172568"
+"ListOfficeKey": "94518"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "13756.278"
+"ParcelNumber": "30354369"
+"ParkingFeatures": array:3 [
0 => "Integrated Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-15T18:42:16Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-15T18:42:16Z"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1660015389"
"RoomType" => "Bedroom"
"ListingId" => "NB141961"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905395"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:33:10.91Z"
]
1 => array:11 [
"RoomKey" => "1660015390"
"RoomType" => "Bedroom"
"ListingId" => "NB141961"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905395"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:33:10.91Z"
]
2 => array:11 [
"RoomKey" => "1660015391"
"RoomType" => "Bedroom"
"ListingId" => "NB141961"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905395"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:33:10.91Z"
]
3 => array:11 [
"RoomKey" => "1660015392"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141961"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905395"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:33:10.91Z"
]
4 => array:11 [
"RoomKey" => "1660015393"
"RoomType" => "Pantry"
"ListingId" => "NB141961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905395"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 5'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:33:10.91Z"
]
5 => array:11 [
"RoomKey" => "1660015394"
"RoomType" => "Kitchen"
"ListingId" => "NB141961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905395"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 20'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:33:10.91Z"
]
6 => array:11 [
"RoomKey" => "1660015395"
"RoomType" => "Living room/Dining room"
"ListingId" => "NB141961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905395"
"RoomLength" => null
"RoomDimensions" => "24'6'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:33:10.91Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29905395/76-squire-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1859927"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "94518"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1921
+"OriginalEntryTimestamp": "2026-06-15T18:33:10.87Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1423040"
+"ListOfficeNationalAssociationId": "1159552"
+"CoListAgentNationalAssociationId": "1200669"
+"CoListOfficeNationalAssociationId": "1159552"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905395_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/94f3f9223c4f3ec2f12338935bdfaa69.webp"
"MediaSize" => 157235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-94f3f9223c4f3ec2f12338935bdfaa69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:10.05Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905395_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/eb9cc8c000ba09811cf981aaf192669b.webp"
"MediaSize" => 146355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-eb9cc8c000ba09811cf981aaf192669b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.09Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905395_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/0019b631dccea7742eab3a43086eeb50.webp"
"MediaSize" => 137010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-0019b631dccea7742eab3a43086eeb50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.11Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905395_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/df2bcc23c243b91dbcce5acbca91b2be.webp"
"MediaSize" => 174333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-df2bcc23c243b91dbcce5acbca91b2be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.09Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905395_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/9880bb460d39ff5d6bcbd9d7cdab5214.webp"
"MediaSize" => 178996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-9880bb460d39ff5d6bcbd9d7cdab5214.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.28Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905395_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/c03d8e369f6649150f20b2f8a26db946.webp"
"MediaSize" => 179151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-c03d8e369f6649150f20b2f8a26db946.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.11Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905395_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/69fd785adac1cd0e1065909b10e42ff2.webp"
"MediaSize" => 54392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-69fd785adac1cd0e1065909b10e42ff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.13Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29905395_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/71fa8ed61fb01308db7cd55473285e5b.webp"
"MediaSize" => 50963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-71fa8ed61fb01308db7cd55473285e5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.12Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29905395_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/6126dcfee15012bf213fdf7936308976.webp"
"MediaSize" => 50549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-6126dcfee15012bf213fdf7936308976.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.11Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29905395_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/5c7bb633d4372aecbbed330c0fb26c2f.webp"
"MediaSize" => 58477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-5c7bb633d4372aecbbed330c0fb26c2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.17Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29905395_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/7f563da2bbf63dc56837d42422b3b934.webp"
"MediaSize" => 48433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-7f563da2bbf63dc56837d42422b3b934.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:10.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29905395_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/dc2e9cf56aebe815a16932077f128a54.webp"
"MediaSize" => 50918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-dc2e9cf56aebe815a16932077f128a54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:10.05Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29905395_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/cd6af9256c130622634a253c2762b390.webp"
"MediaSize" => 56016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-cd6af9256c130622634a253c2762b390.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.13Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29905395_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/89645e899bb69f349737f6f447325ad1.webp"
"MediaSize" => 55831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-89645e899bb69f349737f6f447325ad1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:11.09Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29905395_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/247dfecaeb7b4171c573cf86433d51c0.webp"
"MediaSize" => 65874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-247dfecaeb7b4171c573cf86433d51c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.29Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29905395_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/f2a572d400b5312aa915522309321fd1.webp"
"MediaSize" => 57664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-f2a572d400b5312aa915522309321fd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.28Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29905395_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/213b40b582d2443c498b30b3e454f359.webp"
"MediaSize" => 57715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-213b40b582d2443c498b30b3e454f359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:16.78Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29905395_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/0b714046690a3f02e250b7f00d8988a6.webp"
"MediaSize" => 51766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-0b714046690a3f02e250b7f00d8988a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.92Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29905395_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/050b78673c2be58f799b0624eaf37ff0.webp"
"MediaSize" => 46749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-050b78673c2be58f799b0624eaf37ff0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.25Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29905395_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/234abfaca5db0bf4b9b06ffe4d5406b7.webp"
"MediaSize" => 59780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-234abfaca5db0bf4b9b06ffe4d5406b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.25Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29905395_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/45b2a5b4ec84faa32675e52a1a77a806.webp"
"MediaSize" => 56209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-45b2a5b4ec84faa32675e52a1a77a806.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.76Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29905395_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/718d97e79f2857b7f2a81a7bfbcb2e23.webp"
"MediaSize" => 49721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-718d97e79f2857b7f2a81a7bfbcb2e23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.29Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29905395_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/ad818a998c58915174ce115deaf21266.webp"
"MediaSize" => 28151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-ad818a998c58915174ce115deaf21266.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.35Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29905395_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/25317cb8bd12300d94390015f170b3f9.webp"
"MediaSize" => 29420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-25317cb8bd12300d94390015f170b3f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.29Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29905395_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/d2547ee454b0a0bb549bd744671cb95d.webp"
"MediaSize" => 56227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-d2547ee454b0a0bb549bd744671cb95d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.29Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29905395_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/e67502b0e018a774e28a8cedd126407c.webp"
"MediaSize" => 59434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-e67502b0e018a774e28a8cedd126407c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.35Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29905395_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/5c55e91d0b8ee663f6c201e6ed2e0832.webp"
"MediaSize" => 72721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-5c55e91d0b8ee663f6c201e6ed2e0832.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.76Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29905395_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/11da72da513b2884f2022fd29c547a03.webp"
"MediaSize" => 39488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-11da72da513b2884f2022fd29c547a03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.34Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29905395_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/0f3abc41fd756a597d1d022e84e96fe0.webp"
"MediaSize" => 40412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-0f3abc41fd756a597d1d022e84e96fe0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.22Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29905395_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/d88be23679726216b3a0dce72aceb3c8.webp"
"MediaSize" => 43749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-d88be23679726216b3a0dce72aceb3c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.26Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29905395_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/9f6a892bd5ec1c03b8ed40d299aa9908.webp"
"MediaSize" => 27595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-9f6a892bd5ec1c03b8ed40d299aa9908.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.24Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29905395_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/7521bfbf5e63fe7ebffc9624abeaa74e.webp"
"MediaSize" => 30279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-7521bfbf5e63fe7ebffc9624abeaa74e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.27Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29905395_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/ccb8913fe9afda4ce56cdfc194f973ee.webp"
"MediaSize" => 39754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-ccb8913fe9afda4ce56cdfc194f973ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.24Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29905395_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/6d02bd15af0ac1ebd9a926007cc50de5.webp"
"MediaSize" => 43323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-6d02bd15af0ac1ebd9a926007cc50de5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.76Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29905395_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/3732f60121f5c865f0cee40dd06916bd.webp"
"MediaSize" => 44823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-3732f60121f5c865f0cee40dd06916bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.25Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29905395_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/f95cbf76c7af65dfe3d449a1913434dc.webp"
"MediaSize" => 37202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-f95cbf76c7af65dfe3d449a1913434dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.58Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29905395_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/af56dd21f83f70da1b335f6fad1047f0.webp"
"MediaSize" => 35147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-af56dd21f83f70da1b335f6fad1047f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.76Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29905395_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/39f17d312bc7317f62c6c4972d2a933a.webp"
"MediaSize" => 42484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-39f17d312bc7317f62c6c4972d2a933a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.76Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29905395_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/35a27a9683e6702fd1af344754aa2d14.webp"
"MediaSize" => 43241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-35a27a9683e6702fd1af344754aa2d14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.25Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29905395_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/aa992ef6a046c35162038d9c20d53db9.webp"
"MediaSize" => 40853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-aa992ef6a046c35162038d9c20d53db9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.76Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29905395_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/7783fc932c0dd813d3355681923cbf61.webp"
"MediaSize" => 45248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-7783fc932c0dd813d3355681923cbf61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.35Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29905395_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/bb534eb849d09dcd422b52c469a063e4.webp"
"MediaSize" => 32501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-bb534eb849d09dcd422b52c469a063e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.22Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29905395_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/40b89631dd94c25cfa790e47e16ddd74.webp"
"MediaSize" => 34804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-40b89631dd94c25cfa790e47e16ddd74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.29Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29905395_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/9b39dbb4521fe1357dd8b4683d5db17b.webp"
"MediaSize" => 41936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-9b39dbb4521fe1357dd8b4683d5db17b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.3Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29905395_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/56a40c24c47db01acafca9f942a6ad70.webp"
"MediaSize" => 46499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-56a40c24c47db01acafca9f942a6ad70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.76Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29905395_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/2195dedc1e4588b1628bcd3648a27ecc.webp"
"MediaSize" => 118241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-2195dedc1e4588b1628bcd3648a27ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.5Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29905395_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/592914b683018355f6865a6728eb8369.webp"
"MediaSize" => 116819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-592914b683018355f6865a6728eb8369.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:14.35Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29905395_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/282e124ed6049754547ca20150ab4a68.webp"
"MediaSize" => 130228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-282e124ed6049754547ca20150ab4a68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:13.76Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29905395_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905395/ace3cfa9fdf1147cf16788edcd02b22c.webp"
"MediaSize" => 185773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905395/thumbnail-ace3cfa9fdf1147cf16788edcd02b22c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141961"
"ResourceRecordKey" => "29905395"
"ModificationTimestamp" => "2026-06-15T18:42:12.29Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905395')"
+"ID": "1533856"
}
]
+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 94518" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24821
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2172568" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24794
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29905395'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25144
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29905395'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25160
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29905395' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-65.958984 45.441876)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: "1516209"
+post_author: 1
+"ListingKey": "29883896"
+"ListingId": "NB141633"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T18:40:15Z"
+"RFModificationTimestamp": "2026-06-10T21:46:44Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.31
+"LivingArea": 3546.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0N7"
+"UnparsedAddress": "23 Bitterroot Lane, Quispamsis, New Brunswick E2E0N7"
+"Coordinates": array:2 [
0 => -65.972537
1 => 45.436068
]
+"Latitude": 45.436068
+"Longitude": -65.972537
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to your future dream home! This stunning new construction bungalow offers the perfect blend of modern comfort, thoughtful design, and exceptional versatility. Featuring 3 spacious bedrooms, 2 full bathrooms, and an attached double-car garage, this home is ideal for families or anyone seeking stylish single-level living in one of the area's most desirable neighborhoods. Situated on a beautiful corner lot, you'll enjoy added privacy, extra outdoor space, and impressive curb appeal. Located in a highly sought-after family-friendly community, this home provides convenient access to local schools, shopping, dining, and everyday amenitiesmaking it the perfect place to put down roots and enjoy a vibrant lifestyle. Inside, high-end finishes and carefully selected details create a warm and inviting atmosphere while delivering the modern elegance today's buyers are looking for. Just a short walk away, the Qplex offers outstanding recreational opportunities including an indoor walking track, skating rink, outdoor pool, fitness programs, and more. You'll also have easy access to the Matthew's Brook and Saunders Brook walking trails, perfect for enjoying the outdoors year-round. Adding even more value, the fully finished lower level offers incredible flexibility. Complete with its own kitchen, living area, two beds, 1 full bath, laundry, private entrance, walkout access, and separate driveway, this space is ideal for multi-generational living, accommodating extended family, hosting long-term guests, or providing future income potential. Whether you need extra room today or want the option of supplemental rental income down the road, this thoughtfully designed layout offers endless possibilities. This is a rare opportunity to own a beautiful new home that combines luxury, functionality, & long-term flexibility in an exceptional location. Contact today to learn more or reserve this stunning new home before it's gone! *Completion is expected to be mid-end of July 2026. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-10T21:46:30.931503+00:00"
+"Directions": "Vincent Road to Blue Grass Lane to Bitterroot Lane"
+"ExteriorFeatures": array:2 [
0 => "Vinyl"
1 => "Aluminum/Vinyl"
]
+"Flooring": array:1 [
0 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2026163"
+"ListOfficeKey": "269605"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level lot"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.31"
+"ParcelNumber": "30272256"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-10T18:33:50Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T18:33:50Z"
+"TaxAnnualAmount": "1027.33"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:19 [
0 => array:11 [
"RoomKey" => "1656422985"
"RoomType" => "Living room"
"ListingId" => "NB141633"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 24'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.39Z"
]
1 => array:11 [
"RoomKey" => "1656422986"
"RoomType" => "Kitchen"
"ListingId" => "NB141633"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.39Z"
]
2 => array:11 [
"RoomKey" => "1656422987"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB141633"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.39Z"
]
3 => array:11 [
"RoomKey" => "1656422988"
"RoomType" => "Bedroom"
"ListingId" => "NB141633"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
4 => array:11 [
"RoomKey" => "1656422989"
"RoomType" => "Bedroom"
"ListingId" => "NB141633"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
5 => array:11 [
"RoomKey" => "1656422990"
"RoomType" => "Laundry room"
"ListingId" => "NB141633"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
6 => array:11 [
"RoomKey" => "1656422991"
"RoomType" => "Living room"
"ListingId" => "NB141633"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
7 => array:11 [
"RoomKey" => "1656422992"
"RoomType" => "Living room"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
8 => array:11 [
"RoomKey" => "1656422993"
"RoomType" => "Kitchen"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
9 => array:11 [
"RoomKey" => "1656422994"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
10 => array:11 [
"RoomKey" => "1656422995"
"RoomType" => "Bedroom"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
11 => array:11 [
"RoomKey" => "1656422996"
"RoomType" => "Bedroom"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
12 => array:11 [
"RoomKey" => "1656422997"
"RoomType" => "Dining room"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
13 => array:11 [
"RoomKey" => "1656422998"
"RoomType" => "Foyer"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
14 => array:11 [
"RoomKey" => "1656422999"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
15 => array:11 [
"RoomKey" => "1656423000"
"RoomType" => "Other"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
16 => array:11 [
"RoomKey" => "1656423001"
"RoomType" => "Ensuite"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
17 => array:11 [
"RoomKey" => "1656423002"
"RoomType" => "Laundry room"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.4Z"
]
18 => array:11 [
"RoomKey" => "1656423003"
"RoomType" => "Mud room"
"ListingId" => "NB141633"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883896"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T18:33:50.41Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29883896/23-bitterroot-lane-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1773
+"OriginalEntryTimestamp": "2026-06-10T18:33:50.37Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1305688"
+"ListOfficeNationalAssociationId": "1243995"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29883896_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883896/d12b4c528f29da1fc95a91f4af6b2f4c.webp"
"MediaSize" => 99459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883896/thumbnail-d12b4c528f29da1fc95a91f4af6b2f4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141633"
"ResourceRecordKey" => "29883896"
"ModificationTimestamp" => "2026-06-10T18:33:50.38Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29883896_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883896/fe2ee3a2e00c3010462144c9765bb625.webp"
"MediaSize" => 124118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883896/thumbnail-fe2ee3a2e00c3010462144c9765bb625.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141633"
"ResourceRecordKey" => "29883896"
"ModificationTimestamp" => "2026-06-10T18:33:50.38Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29883896_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883896/25240402fa7a913b3ba266f87809dc36.webp"
"MediaSize" => 150220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883896/thumbnail-25240402fa7a913b3ba266f87809dc36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141633"
"ResourceRecordKey" => "29883896"
"ModificationTimestamp" => "2026-06-10T18:33:50.38Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29883896_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883896/555ff4236fdda6354d5f0faf4cb5ef5a.webp"
"MediaSize" => 42993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883896/thumbnail-555ff4236fdda6354d5f0faf4cb5ef5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29883896')"
+"ID": "1516209"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1511379"
+post_author: 1
+"ListingKey": "29876577"
+"ListingId": "NB141078"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:30:06Z"
+"RFModificationTimestamp": "2026-06-12T15:31:52Z"
+"ListPrice": 664900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 14445.17
+"LivingArea": 3011.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G0E4"
+"UnparsedAddress": "11 Fieldcrest Drive, Quispamsis, New Brunswick E2G0E4"
+"Coordinates": array:2 [
0 => -65.956744
1 => 45.442046
]
+"Latitude": 45.442046
+"Longitude": -65.956744
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "11 Fieldcrest Drive, where timeless design, exceptional living space, and a backyard retreat come together in one of Quispamsis most established neighbourhoods. This impressive stone-accented two-storey home offers the perfect blend of elegance and family functionality, all set on a beautifully landscaped property. Inside you will immediately appreciate the warmth of rich cherry hardwood floors and the inviting layout. The heart of the home is the stunning kitchen featuring dark cabinetry, granite countertops, and a massive centre island that naturally becomes the gathering place for family and friends. A formal dining room is ready for special occasions, while the main floor office/den provides a quiet space for working from home or managing busy family life. Open concept galore..just off the kitchen the sun-filled family room overlooks the backyard and offers seamless access to the deck through patio doors, creating an effortless indoor-outdoor lifestyle. Upstairs, three generously sized bedrooms provide comfortable accommodations for the entire family. The primary suite is a true retreat, complete with a spa-inspired ensuite bath designed for relaxation. A second full bathroom and the convenience of an upper-level laundry room complete the second floor. The fully finished basement expands the living space even further with a full bathroom and flexible rooms ideal for recreation, fitness, guests, or hobbies. Outside is where this property truly shines. The fully fenced backyard has been transformed into a private oasis with mature landscaping, colourful flower beds, beautiful shrubs, a newer above-ground pool, and a built-in hot tub. Whether hosting summer gatherings or enjoying a quiet evening under the stars, this outdoor space delivers the lifestyle buyers dream about. A rare opportunity to own a move-in ready family home with exceptional outdoor living in a mature Quispamsis neighbourhood close to schools, recreation, walking trails, and all amenities. (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-09T19:10:14.852940+00:00"
+"Directions": "Squire to Hearthstone to Fieldcrest"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Stove"
3 => "Electric"
4 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2026822"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "14445.17"
+"ParcelNumber": "30260426"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-10T14:33:12Z"
+"PhotosCount": 40
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-12T15:22:47Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "6937.65"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=REboM7KAuGv"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29876577/11-fieldcrest-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2053
+"OriginalEntryTimestamp": "2026-06-09T16:45:49.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1306334"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876577')"
+"ID": "1511379"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1509880"
+post_author: 1
+"ListingKey": "29875169"
+"ListingId": "NB141211"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T18:50:05Z"
+"RFModificationTimestamp": "2026-06-14T18:51:28Z"
+"ListPrice": 299000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 15607.0
+"LivingArea": 1904.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E1M8"
+"UnparsedAddress": "11 Cardinal Terrace, Quispamsis, New Brunswick E2E1M8"
+"Coordinates": array:2 [
0 => -65.983681
1 => 45.442644
]
+"Latitude": 45.442644
+"Longitude": -65.983681
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 11 Cardinal Terrace in beautiful Quispamsis. This home is ready for its next chapter and represents a great opportunity for someone to make it their own. Tucked away on a quiet cul-de-sac, this home is in a desirable location with quick highway access and close proximity to countless amenities. One of the main attractions for this location is the Quispamsis Q-Plex, which is just a ~10 minute walk away. The Q-Plex is one of the area's most popular recreation areas and includes soccer and baseball fields, tennis and pickleball courts, community garden, hockey rink, pools, indoor walking track, and playground. This home is also within walking distance to the Kennebecasis River, Quispams renowned walking trails, and you are minutes to several public beaches and top-tier schools. Outside you will find the star of the show - an impressive 44 x 28 garage. This garage features an oversized double car garage space measuring 28 x 28, and an attached 415 square foot workshop space with its own electrical panel. The potential is limitless with this space. The main floor of the home offers 3 bedrooms and a full bathroom, kitchen, and a bright, open living and dining space with several windows welcoming the natural light. Downstairs you will find a large family room with French doors which would make a great home office, laundry room, and a spacious living room with access to an unfinished storage room with shelving. The home is a true fixer-upper and with some investment and sweat equity, this property has potential to be a perfect family home. **Some photos have been virtually staged to show the potential possibilities for this home. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-09T14:34:24.946265+00:00"
+"Directions": "Meenans Cove Rd to Cardinal Terrace."
+"ExteriorFeatures": array:2 [
0 => "Vinyl"
1 => "Brick Veneer"
]
+"Flooring": array:4 [
0 => "Tile"
1 => "Hardwood"
2 => "Ceramic"
3 => "Linoleum"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2075084"
+"ListOfficeKey": "269605"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "15607"
+"ParcelNumber": "00453852"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:21:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-14T18:43:04Z"
+"TaxAnnualAmount": "6704.3"
+"WaterSource": array:1 [
0 => "Well"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29875169/11-cardinal-terrace-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1026
+"OriginalEntryTimestamp": "2026-06-09T14:14:51.65Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1350319"
+"ListOfficeNationalAssociationId": "1243995"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875169')"
+"ID": "1509880"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: "1496235"
+post_author: 1
+"ListingKey": "29845208"
+"ListingId": "NB140863"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T13:50:34Z"
+"RFModificationTimestamp": "2026-06-03T15:35:52Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 43378.0
+"LivingArea": 2576.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G1Y5"
+"UnparsedAddress": "3 Regal Drive, Quispamsis, New Brunswick E2G1Y5"
+"Coordinates": array:2 [
0 => -65.936957
1 => 45.446288
]
+"Latitude": 45.446288
+"Longitude": -65.936957
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 3 Regal Drive, a beautifully updated family home tucked away on a private lot of nearly an acre in a sought-after community close to Meenans Cove Beach and the Q Plex. Offering 3 bedrooms with potential for 2 additional bedrooms downstairs, a finished basement, and an attached double-car garage, this home offers flexibility for growing families. Recent updates include stunning new hardwood flooring throughout, a beautifully renovated kitchen, and a heat pump for year-round comfort. Large sun-filled rooms create a bright and inviting atmosphere, while the spacious primary suite features its own private ensuite. Cozy up by the woodstove in the lower-level rec room or enjoy entertaining in the open concept kitchen and living room spaces. NOTE: Back deck will be resurfaced for new owners. (id:62783)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-03T15:35:40.106843+00:00"
+"Directions": "Meenan's Cove Road to Colonial to Regal."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Stove"
3 => "Electric"
4 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2041971"
+"ListOfficeKey": "279450"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "43378"
+"ParcelNumber": "30090138"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T13:44:59Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-03T13:44:59Z"
+"TaxAnnualAmount": "4451.96"
+"WaterSource": array:1 [
0 => "Well"
]
+"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/29845208/3-regal-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1615686"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279450"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1288
+"OriginalEntryTimestamp": "2026-06-03T13:44:59.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1317832"
+"ListOfficeNationalAssociationId": "1304536"
+"CoListAgentNationalAssociationId": "1159555"
+"CoListOfficeNationalAssociationId": "1304536"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29845208')"
+"ID": "1496235"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: "1453364"
+post_author: 1
+"ListingKey": "29795592"
+"ListingId": "NB139450"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T23:20:57Z"
+"RFModificationTimestamp": "2026-06-08T23:23:40Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 12281.0
+"LivingArea": 3188.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E3G0A8"
+"UnparsedAddress": "11 Cobblestone Drive, Quispamsis, New Brunswick E3G0A8"
+"Coordinates": array:2 [
0 => -65.960303
1 => 45.442298
]
+"Latitude": 45.442298
+"Longitude": -65.960303
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 11 Cobblestone Drive, a beautifully finished home offering three fully developed levels of living space, stunning river views, and the perfect blend of comfort, functionality, and style. From the moment you step inside, youll appreciate the abundance of natural light pouring through the many windows, creating a warm and inviting atmosphere throughout the home. The main level features a bright open-concept layout with a spacious kitchen flowing seamlessly into the dining and living areasideal for entertaining family and friends. New electric fireplace for cozy days. Step outside to the expansive wrap-around deck and enjoy the large backyard, now complete with a new chain-link fence, perfect for children, pets, and outdoor gatherings. This level also includes a convenient mudroom, main-floor laundry, half bath, and direct access to the attached garage. Upstairs, youll find two generously sized bedrooms, a full bathroom, and a spacious primary suite complete with a walk-in closet and private ensuite. The standout feature is the incredible private deck off the primary bedroom, where you can relax while taking in breathtaking river views, watching the ferry cross, and enjoying unforgettable sunsets. The fully finished walkout lower level offers even more versatile living space with a large family room with pellet stove, full bathroom, and an additional office or flex room that could easily serve as a fourth bedroom, guest room, or home gym. Additional updates and features include new roof shingles in 2022, a paved driveway, landscaped grounds, and an attached garage that has been fully insulated and rewired. Wiring for a future hot tub is already in place, making it easy to create your own backyard oasis. Located in a highly desirable neighborhood close to amenities and outdoor recreation, this exceptional property truly has it all. Dont miss your chance to call this incredible home your own! (id:62783)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-23T13:46:59.677216+00:00"
+"Directions": "Meenan's Cove Rd to Cobblestone."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Stove"
3 => "Electric"
4 => "Pellet"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2016855"
+"ListOfficeKey": "300685"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "12281"
+"ParcelNumber": "30247365"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-23T11:49:34Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-08T23:14:25Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "6763.66"
+"View": "River view"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29795592/11-cobblestone-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2145994"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "300685"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2636
+"OriginalEntryTimestamp": "2026-05-23T11:49:34.28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1298085"
+"ListOfficeNationalAssociationId": "1491748"
+"CoListAgentNationalAssociationId": "1397276"
+"CoListOfficeNationalAssociationId": "1491748"
+"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": 24
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29795592')"
+"ID": "1453364"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: "1454156"
+post_author: 1
+"ListingKey": "29789466"
+"ListingId": "NB138823"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T17:50:53Z"
+"RFModificationTimestamp": "2026-05-31T17:51:17Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 4849.0
+"LivingArea": 2000.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E6A1"
+"UnparsedAddress": "38 Merritt Hill Road, Quispamsis, New Brunswick E2E6A1"
+"Coordinates": array:2 [
0 => -65.978705
1 => 45.450635
]
+"Latitude": 45.450635
+"Longitude": -65.978705
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to Merritt Hill, one of the Kennebecasis Valleys most cherished communities where peaceful streets, friendly waves and a true sense of belonging create the kind of lifestyle people dream of. Nestled close to the beautiful Kennebecasis River, this quiet, safe neighbourhood offers a feeling that is becoming increasingly rare; neighbours become friends, evening walks feel effortless and community is woven into everyday life. Perfectly suited for those looking to embrace a low maintenance lifestyle, this beautifully designed garden home offers a floor plan buyers continually fall in love with. The spacious main level primary suite provides comfort and privacy with its own ensuite bath and walk-in closet. Vaulted ceilings create an airy openness throughout the home while large windows fill the space with warm natural light. Hardwood floors, white trim, french doors and abundant cabinetry add timeless appeal. Gather around the center island, enjoy peaceful coffee on the deck, host family dinners with treasured heirlooms nearby, or simply watch the world stroll by. The finished lower level offers a generous bedroom, 3/4 bath, oversized family room plus exceptional laundry and storage space. As an estate sale there will be no property disclosure statement provided. This home can accommodate a quick closing. The HOA fee is $100. a month . (id:62650)"
+"AssociationFee": "100"
+"AssociationFeeFrequency": "Monthly"
+"BathroomsPartial": 1
+"CreationDate": "2026-05-22T17:30:55.667154+00:00"
+"Directions": "Gondola Point Road towards the end, turn right onto Merritt Hill"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Carpeted"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422684"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "4849"
+"ParcelNumber": "30230403"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-22T14:12:50Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-31T17:43:05Z"
+"TaxAnnualAmount": "4070.73"
+"View": "River view"
+"WaterBodyName": "Kennebecasis"
+"WaterSource": array:2 [
0 => "Shared Well"
1 => "Well"
]
+"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/29789466/38-merritt-hill-road-quispamsis"
+"StructureType": array:1 [
0 => "Garden Home"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1000
+"OriginalEntryTimestamp": "2026-05-22T14:12:50.52Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1085897"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29789466')"
+"ID": "1454156"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1422416"
+post_author: 1
+"ListingKey": "29750342"
+"ListingId": "NB139409"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-20T00:01:02Z"
+"RFModificationTimestamp": "2026-05-20T00:06:26Z"
+"ListPrice": 809900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 1190.0
+"LivingArea": 2366.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0X1"
+"UnparsedAddress": "8 Galmorgan Avenue, Quispamsis, New Brunswick E2E0X1"
+"Coordinates": array:2 [
0 => -65.978666
1 => 45.431762
]
+"Latitude": 45.431762
+"Longitude": -65.978666
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 8 Galmorgan, a stunning modern bungalow nestled in the heart of sought-after Quispamsis. Thoughtfully designed with upscale finishes and an exceptional layout, this home offers the perfect blend of luxury, comfort, and functionality. The striking exterior with double attached garage and covered front entry creates incredible curb appeal from the moment you arrive. Step inside to a bright and airy open-concept main level featuring soaring ceilings, oversized windows, and beautiful hardwood flooring throughout. The chef-inspired kitchen is truly the centerpiece of the home, showcasing quartz countertops, a large island, custom cabinetry, stainless steel appliances, and stylish modern lighting. The spacious living and dining areas are perfect for entertaining or relaxing while enjoying the natural light pouring in from the back windows and patio doors leading to the covered deck. The main floor offers 3 generous bedrooms and 2 full bathrooms, including a gorgeous primary suite complete with a spa-like ensuite featuring a tiled shower, freestanding soaker tub, and elegant finishes. The finished basement provides incredible additional living space with 2 more bedrooms, a dedicated office, a large family room, and another full bathroom ideal for guests, growing families, or multi-generational living. Located in a desirable neighborhood close to schools, amenities, walking trails, and recreation, this beautifully crafted home offers style, space, and quality throughout. A must-see property that delivers modern living at its finest. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-14T13:43:10.095503+00:00"
+"Directions": "Vincent Rd to Galmorgan Dr"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:4 [
0 => "Tile"
1 => "Hardwood"
2 => "Ceramic"
3 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Forced air"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2189248"
+"ListOfficeKey": "291450"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1190"
+"ParcelNumber": "30344824"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-20T00:00:54Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-20T00:00:54Z"
+"TaxAnnualAmount": "10203"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=tetSmPvEUA0"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"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/29750342/8-galmorgan-avenue-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2162208"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291450"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1691
+"OriginalEntryTimestamp": "2026-05-14T12:10:35.18Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1438215"
+"ListOfficeNationalAssociationId": "1398077"
+"CoListAgentNationalAssociationId": "1413140"
+"CoListOfficeNationalAssociationId": "1398077"
+"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": 33
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29750342')"
+"ID": "1422416"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25231
+post_id: "1395301"
+post_author: 1
+"ListingKey": "29713770"
+"ListingId": "NB137618"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-30T19:50:23Z"
+"RFModificationTimestamp": "2026-05-30T19:51:39Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 12916.69
+"LivingArea": 4200.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0L2"
+"UnparsedAddress": "51 Shornecliff Drive, Quispamsis, New Brunswick E2E0L2"
+"Coordinates": array:2 [
0 => -65.970483
1 => 45.429816
]
+"Latitude": 45.429816
+"Longitude": -65.970483
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this exceptional executive home in one of Quispamsis most sought-after neighbourhoods. Just minutes from schools, the QPlex recreation centre , restaurants, and everyday amenities, this meticulously maintained residence offers 6 bedrooms, a dedicated home office, and 4 bathrooms a rare combination of space, comfort, and functionality. The thoughtfully designed main level offers an ideal blend of formal and everyday living spaces. The chef-inspired kitchen features granite countertops, stainless steel appliances, extensive cabinetry, and abundant storage, seamlessly flowing into the breakfast area and elegant living room. Patio doors lead to an expansive deck with a gazebo-covered seating area, perfect for the summer gatherings, relaxing evenings and entertaining family and friends. This level also features a beautiful formal dining room, a warm family room, and a dedicated office complete with impressive built-in shelving, while oversized arched windows fill the front living spaces with natural light and timeless architectural charm. Upstairs offers four spacious bedrooms, including an impressive primary suite complete with a walk-in closet and a luxurious ensuite featuring a soaker tub, walk-in shower, and double vanity. An additional full bathroom serves the remaining bedrooms. The fully finished basement provides exceptional flexibility with a massive rec room and two additional large bedrooms, offering endless possibilities for a home theatre, gym, games area, workshop, second office, or guest accommodations. A full bathroom and an expansive storage room complete the lower level. Additional highlights include ducted heat pump for year-round comfort, a spacious mudroom, double attached garage, and a double-wide paved driveway with ample parking for family and guests. Rarely does a home offer this level of living space, versatility, and timeless comfort in such a desirable location. Book your viewing today! (id:62783)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-07T13:37:16.206578+00:00"
+"Directions": "Quispamsis Road to Cambridge, roundabout to Grassmere, right on Shornecliff Drive"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2186384"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level lot"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "12916.69"
+"ParcelNumber": "30253645"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-07T13:11:10Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-30T19:43:22Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "9319.7"
+"VirtualTourURLUnbranded": "https://youtu.be/QnQoMfxssrI"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29713770/51-shornecliff-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 2800
+"OriginalEntryTimestamp": "2026-05-07T13:11:10.51Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1435975"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 40
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29713770')"
+"ID": "1395301"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: "1322698"
+post_author: 1
+"ListingKey": "29608485"
+"ListingId": "NB137289"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-15T17:25:23Z"
+"RFModificationTimestamp": "2026-04-15T18:42:24Z"
+"ListPrice": 514900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 895.0
+"LivingArea": 1646.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G1Y9"
+"UnparsedAddress": "8 Bellbottom Way, Quispamsis, New Brunswick E2G1Y9"
+"Coordinates": array:2 [
0 => -65.969506
1 => 45.436005
]
+"Latitude": 45.436005
+"Longitude": -65.969506
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 8 Bellbottom Way, an under construction bungalow designed for easy one-level living in a thoughtfully planned neighbourhood. The main level features an open-concept kitchen, dining, and living area with a natural flow for everyday use. Three bedrooms include a primary suite with walk-in closet and private ensuite. A dedicated main-level laundry room with cabinetry and quartz countertop adds both convenience and functional workspace. The attached 24 x 21 garage with built-in storage provides excellent functionality and can also serve as a mudroom space. A front porch and back deck offer outdoor living options. The unfinished basement includes plumbing rough-ins for a future bathroom and provides over 1,600 sq. ft. of additional space, offering strong potential to add finished square footage and value over time. Currently under construction, this home is expected to be ready for new owners in approximately 4 - 5 weeks. Backed by an 8-year Lux Home Warranty, this home offers the benefits of new construction in a growing community. Located in Quispamsis, youll enjoy a neighbourhood setting with a rural feel, while still being close to trails, schools, and everyday amenities. This property is part of a condominium corporation responsible for the shared community well and septic system. The monthly condo fee of $100 includes contributions to the reserve fund and maintenance of shared systems. (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "Raised bungalow"
]
+"AssociationFee": "100"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-04-15T18:42:11.604941+00:00"
+"Directions": "Elliot rd, turn onto Corduory Rd, left onto Cargo, and left onto Bellbottom Way."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2008759"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "895"
+"ParcelNumber": "30357867"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-04-15T17:11:28Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-04-15T17:11:28Z"
+"TaxAnnualAmount": "3149.96"
+"WaterSource": array:2 [
0 => "Well"
1 => "Community Water System"
]
+"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/29608485/8-bellbottom-way-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1646
+"OriginalEntryTimestamp": "2026-04-15T17:11:28.58Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1290669"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 62
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29608485')"
+"ID": "1322698"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 11
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]