array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29916383 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1540501"
+post_author: 1
+"ListingKey": "29916383"
+"ListingId": "NB142092"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:50:04Z"
+"RFModificationTimestamp": "2026-06-17T18:16:03Z"
+"ListPrice": 459000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 5000.0
+"LivingArea": 1180.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E0M6"
+"UnparsedAddress": "60 Kaitlyn Street, Rothesay, New Brunswick E2E0M6"
+"Coordinates": array:2 [
0 => -65.985805
1 => 45.408165
]
+"Latitude": 45.408165
+"Longitude": -65.985805
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Maintenance-Free Luxury Living in the Heart of Rothesay! Welcome to Rothesays newest garden home community, where luxury and low-maintenance living come together in one exceptional location. Currently pre-selling for Spring 2027 occupancy, these beautifully designed one-level homes offer 1,180 sq. ft. of thoughtfully planned living space, complete with full walk-out basements and quality craftsmanship. Step inside and discover bright, open-concept living enhanced by 9-foot ceilings, custom cabinetry, and modern finishes throughout. The spacious kitchen flows seamlessly into the dining and living areas, creating the perfect setting for entertaining. The primary suite offers a private retreat with a walk-in closet and custom ensuite, while a second bedroom provides flexibility for guests, hobbies, or a home office. Convenient main-floor laundry ensures everything you need is on one level. What truly sets Glengary Estates apart is the lifestyle. Enjoy the freedom of homeownership without the hassle of exterior maintenance. The homeowner association takes care of lawn maintenance and snow removal, allowing you to spend less time working around the house and more time enjoying life. Whether youre travelling, spending winters away, or simply looking to simplify your lifestyle, these homes offer true lock-and-leave convenience. Each home also includes: Full walk-out basement with future development potential Attached garage Private rear deck and outdoor living space Ductless heat pump for efficient heating and cooling Enhanced insulation for year-round comfort and energy savings. Nestled just off the scenic Gondola Point Road, enjoy easy access to walking trails, Riverside Golf Club, pickleball courts, restaurants, shopping, and everyday amenitiesall while being surrounded by the natural beauty and charm that make Rothesay such a sought-after community. Reserve your home today to secure pricing and personalized finishes before construction is complete. (id:62650)"
+"Basement": array:3 [
0 => "Unfinished"
1 => "Full"
2 => "Walk out"
]
+"Cooling": array:3 [
0 => "Air exchanger"
1 => "Heat Pump"
2 => "Air Conditioned"
]
+"CreationDate": "2026-06-17T17:11:37.452452+00:00"
+"Directions": "Gondola Point Road to Issac street, left on to Kaitlyn St."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248223"
+"ListOfficeKey": "279450"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "5000"
+"ParcelNumber": "30146708 (a portion of)"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T17:41:49Z"
+"PhotosCount": 11
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T17:42:29Z"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1661320747"
"RoomType" => "Other"
"ListingId" => "NB142092"
"RoomLevel" => "Unknown"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.28Z"
]
1 => array:11 [
"RoomKey" => "1661320748"
"RoomType" => "Other"
"ListingId" => "NB142092"
"RoomLevel" => "Unknown"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.29Z"
]
2 => array:11 [
"RoomKey" => "1661320749"
"RoomType" => "Other"
"ListingId" => "NB142092"
"RoomLevel" => "Unknown"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.29Z"
]
3 => array:11 [
"RoomKey" => "1661320750"
"RoomType" => "Other"
"ListingId" => "NB142092"
"RoomLevel" => "Unknown"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.29Z"
]
4 => array:11 [
"RoomKey" => "1661320751"
"RoomType" => "Other"
"ListingId" => "NB142092"
"RoomLevel" => "Unknown"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.29Z"
]
5 => array:11 [
"RoomKey" => "1661320752"
"RoomType" => "3pc Bathroom"
"ListingId" => "NB142092"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.29Z"
]
6 => array:11 [
"RoomKey" => "1661320753"
"RoomType" => "Bedroom"
"ListingId" => "NB142092"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.29Z"
]
7 => array:11 [
"RoomKey" => "1661320754"
"RoomType" => "Other"
"ListingId" => "NB142092"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.29Z"
]
8 => array:11 [
"RoomKey" => "1661320755"
"RoomType" => "3pc Ensuite bath"
"ListingId" => "NB142092"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.29Z"
]
9 => array:11 [
"RoomKey" => "1661320756"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB142092"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.3Z"
]
10 => array:11 [
"RoomKey" => "1661320757"
"RoomType" => "Kitchen"
"ListingId" => "NB142092"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.3Z"
]
11 => array:11 [
"RoomKey" => "1661320758"
"RoomType" => "Great room"
"ListingId" => "NB142092"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916383"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 19'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:42:29.3Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29916383/60-kaitlyn-street-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1180
+"OriginalEntryTimestamp": "2026-06-17T16:44:46.62Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1487110"
+"ListOfficeNationalAssociationId": "1304536"
+"Media": array:11 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29916383_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/2af34c627a307882f542bf008201b4bf.webp"
"MediaSize" => 86020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-2af34c627a307882f542bf008201b4bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Exterior-Virtual Rendering"
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29916383_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/19e22a5757a20be16fc4430e159a23f8.webp"
"MediaSize" => 63027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-19e22a5757a20be16fc4430e159a23f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen to Great Room-Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29916383_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/344ab85e28cca266f2964b00b8230440.webp"
"MediaSize" => 59712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-344ab85e28cca266f2964b00b8230440.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Great Room to Kitchen-Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29916383_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/cd90e0adf529f8540da074da6d35c119.webp"
"MediaSize" => 66704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-cd90e0adf529f8540da074da6d35c119.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Great Room-Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29916383_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/16049874c16873763cba4d25d81ed972.webp"
"MediaSize" => 67812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-16049874c16873763cba4d25d81ed972.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 2/Guest Room-Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29916383_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/5bee7052d90a881e127f332c0a4053e7.webp"
"MediaSize" => 62031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-5bee7052d90a881e127f332c0a4053e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom- Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29916383_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/15bcd8929aa34a5e2e2c4b166f931e9a.webp"
"MediaSize" => 57255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-15bcd8929aa34a5e2e2c4b166f931e9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Ensuite-Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29916383_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/79702b1bd3ee16d33313691f28d5c216.webp"
"MediaSize" => 117731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-79702b1bd3ee16d33313691f28d5c216.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear Exterior-Virtual Rendering"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29916383_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/f22832ee060cbde9eb4fe658613f3918.webp"
"MediaSize" => 110252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-f22832ee060cbde9eb4fe658613f3918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Exterior-Virtual Rendering"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29916383_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/1a51ce6d079e9285a2a4683589b0b235.webp"
"MediaSize" => 97939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-1a51ce6d079e9285a2a4683589b0b235.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear Exterior-Virtual Rendering"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29916383_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916383/f2fbae776ae3583deb3a2890dcbe81be.webp"
"MediaSize" => 82033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916383/thumbnail-f2fbae776ae3583deb3a2890dcbe81be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior Front-Virtual Rendering"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142092"
"ResourceRecordKey" => "29916383"
"ModificationTimestamp" => "2026-06-17T16:44:46.62Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916383')"
+"ID": "1540501"
}
]
+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 279450" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24715
+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 2248223" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24719
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24800
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2248223"
+"ModificationTimestamp": "2025-09-09T13:59:08Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2248223"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2248223')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29916383'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25089
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29916383'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25105
+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 '29916383' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-65.985805 45.408165)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25158
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25152
+post_id: "1541511"
+post_author: 1
+"ListingKey": "29918146"
+"ListingId": "NB141541"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:20:17Z"
+"RFModificationTimestamp": "2026-06-17T20:53:21Z"
+"ListPrice": 289900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 27695.0
+"LivingArea": 2415.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2K4N5"
+"UnparsedAddress": "18 McCarron Drive, Quispamsis, New Brunswick E2K4N5"
+"Coordinates": array:2 [
0 => -65.9617
1 => 45.413395
]
+"Latitude": 45.413395
+"Longitude": -65.9617
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Will this highly sought after neighborhood be where you make new memories? Nestled on over half an acre in the heart of Quispamsis, just minutes from Richie Lake beach (swimming, fishing & kayaking). The home is surrounded by picturesque grounds, oversized backyard with its own babbling brook, mature trees and plenary of room for gardens, recreation or future projects. This is complimented by a unique interlocking stone driveway for 5+ vehicles and a detached workshop with power, perfect for a studio, workshop or creative retreat. The main home offers comfortable two bedroom living with functional space throughout, including on oversized living room and eat in kitchen. Classic finishes throughout provide warmth and character and great bones for those with a flair for transforming spaces. A rare and valuable feature for the area is the private one-bedroom suite above the attached garage, complete with its own kitchen, bath and living area with two decks. Ideal for multi-generational living, accommodating adult kids, guests or exploring income potential, this flexible space adds tremendous versatility. Additional highlights include a full walkout basement with rec room, workshop, laundry and half bath, dual wood and oil heating system, a winters worth of wood and a backup generator. Lovingly maintained over the years, this estate sale is being offered as is where is. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Raised bungalow"
1 => "2 Level"
]
+"Basement": array:3 [
0 => "Partially finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-17T20:53:10.053619+00:00"
+"Directions": "travelling from Hampton via McKay hwy take the Gondola Pt Arterial to Hampton rd. Turm right onto McCarron. From Saint John take the same exit"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Oil"
2 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2057881"
+"ListOfficeKey": "94518"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Treed"
1 => "Sloping"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "27695"
+"ParcelNumber": "00254896"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-17T20:15:15Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T20:15:15Z"
+"TaxAnnualAmount": "3411"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1661453464"
"RoomType" => "Other"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.5Z"
]
1 => array:11 [
"RoomKey" => "1661453465"
"RoomType" => "Laundry room"
"ListingId" => "NB141541"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.5Z"
]
2 => array:11 [
"RoomKey" => "1661453466"
"RoomType" => "Hobby room"
"ListingId" => "NB141541"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "44'6'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.5Z"
]
3 => array:11 [
"RoomKey" => "1661453467"
"RoomType" => "Recreation room"
"ListingId" => "NB141541"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "21'2'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.5Z"
]
4 => array:11 [
"RoomKey" => "1661453468"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB141541"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 5'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.5Z"
]
5 => array:11 [
"RoomKey" => "1661453469"
"RoomType" => "Living room"
"ListingId" => "NB141541"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "12' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.5Z"
]
6 => array:11 [
"RoomKey" => "1661453470"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "NB141541"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.51Z"
]
7 => array:11 [
"RoomKey" => "1661453471"
"RoomType" => "Bedroom"
"ListingId" => "NB141541"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.51Z"
]
8 => array:11 [
"RoomKey" => "1661453472"
"RoomType" => "Foyer"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 4'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.51Z"
]
9 => array:11 [
"RoomKey" => "1661453473"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.51Z"
]
10 => array:11 [
"RoomKey" => "1661453474"
"RoomType" => "Living room"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "22'4'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.51Z"
]
11 => array:11 [
"RoomKey" => "1661453475"
"RoomType" => "Bedroom"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.51Z"
]
12 => array:11 [
"RoomKey" => "1661453476"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.51Z"
]
13 => array:11 [
"RoomKey" => "1661453477"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.51Z"
]
14 => array:11 [
"RoomKey" => "1661453478"
"RoomType" => "Family room"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.52Z"
]
15 => array:11 [
"RoomKey" => "1661453479"
"RoomType" => "Kitchen"
"ListingId" => "NB141541"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918146"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:15.52Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29918146/18-mccarron-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1965
+"OriginalEntryTimestamp": "2026-06-17T20:02:44.1Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1333039"
+"ListOfficeNationalAssociationId": "1159552"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918146_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/94baef33ff7229efc325ecdc20ae896a.webp"
"MediaSize" => 169559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-94baef33ff7229efc325ecdc20ae896a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:01.99Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918146_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/cf96b1a96786c74e325f0e95c5ec2a6d.webp"
"MediaSize" => 163233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-cf96b1a96786c74e325f0e95c5ec2a6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:01.99Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29918146_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/5182203329526979b40150f7d33ac2ac.webp"
"MediaSize" => 91180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-5182203329526979b40150f7d33ac2ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ample parking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:02.03Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29918146_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/26234e9bd533c2711704d86c4ad74e74.webp"
"MediaSize" => 92654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-26234e9bd533c2711704d86c4ad74e74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "97x338 including brook"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:01.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29918146_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/cce8e7e17a6bf8471250b4e498f3bfdf.webp"
"MediaSize" => 71077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-cce8e7e17a6bf8471250b4e498f3bfdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mature private lot"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:02.03Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29918146_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/bb99e524e4bd21046d6586b4fb810abd.webp"
"MediaSize" => 135901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-bb99e524e4bd21046d6586b4fb810abd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:01.99Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29918146_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/9d18f13e66e52a3e122a104994cff50f.webp"
"MediaSize" => 223136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-9d18f13e66e52a3e122a104994cff50f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.31Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29918146_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/aab80b0a708f3ff4b37fab22f8a435fb.webp"
"MediaSize" => 208273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-aab80b0a708f3ff4b37fab22f8a435fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.4Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29918146_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/4f22576170cc6c8d2dd78e4c13021eb2.webp"
"MediaSize" => 155508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-4f22576170cc6c8d2dd78e4c13021eb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.31Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29918146_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/a2531ea4f314c86483d1bb18741bd04f.webp"
"MediaSize" => 154255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-a2531ea4f314c86483d1bb18741bd04f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.31Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29918146_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/835935f9a48adf72480be10dfebe179c.webp"
"MediaSize" => 93516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-835935f9a48adf72480be10dfebe179c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.36Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29918146_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/30c484129906099bd7fe0f55e0e3aa86.webp"
"MediaSize" => 108868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-30c484129906099bd7fe0f55e0e3aa86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.33Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29918146_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/9f0e7d40a0905567c756ac21461b7c41.webp"
"MediaSize" => 84423
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-9f0e7d40a0905567c756ac21461b7c41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.36Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29918146_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/016a0e3cba7df8e3274d1efbf8860f2b.webp"
"MediaSize" => 103899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-016a0e3cba7df8e3274d1efbf8860f2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.31Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29918146_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/ac4ca381eeea11064ffe9d979a0cf3cb.webp"
"MediaSize" => 91381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-ac4ca381eeea11064ffe9d979a0cf3cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.32Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29918146_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/63fe4ea0579d18145327a447a0f3c238.webp"
"MediaSize" => 60759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-63fe4ea0579d18145327a447a0f3c238.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.31Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29918146_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/bf236c6301381c088430c8835daf0c49.webp"
"MediaSize" => 84259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-bf236c6301381c088430c8835daf0c49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.37Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29918146_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/88d1cc4c749e30dddf0c451d917fe544.webp"
"MediaSize" => 116562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-88d1cc4c749e30dddf0c451d917fe544.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.4Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29918146_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/2e92064a3a060925abf13d3a46431d0d.webp"
"MediaSize" => 119572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-2e92064a3a060925abf13d3a46431d0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.37Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29918146_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/35c1422e3b4ca8fb5f7168d8e344f9e6.webp"
"MediaSize" => 70193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-35c1422e3b4ca8fb5f7168d8e344f9e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.38Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29918146_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/cfa64e25ea8a14a3926bebd4fbd04584.webp"
"MediaSize" => 142849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-cfa64e25ea8a14a3926bebd4fbd04584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.4Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29918146_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/a1b2dc74f50ceba78906c9f696d755e5.webp"
"MediaSize" => 110355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-a1b2dc74f50ceba78906c9f696d755e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.37Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29918146_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/fae1487fcca11b7df1dd78c8bd5830d9.webp"
"MediaSize" => 92916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-fae1487fcca11b7df1dd78c8bd5830d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.37Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29918146_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/b910a8030ae10c37aa1b4e5399a310b7.webp"
"MediaSize" => 39916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-b910a8030ae10c37aa1b4e5399a310b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.37Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29918146_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/a2a69bb99df5dcfcac29632396407c44.webp"
"MediaSize" => 54955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-a2a69bb99df5dcfcac29632396407c44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.38Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29918146_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/5defa0d22b299afaa481e23b38ae468e.webp"
"MediaSize" => 57153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-5defa0d22b299afaa481e23b38ae468e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.42Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29918146_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/fc00d1569b54914b3cd9a14669190acd.webp"
"MediaSize" => 52684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-fc00d1569b54914b3cd9a14669190acd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.38Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29918146_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/6ec558842c090f7379da0984beccc0fe.webp"
"MediaSize" => 55323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-6ec558842c090f7379da0984beccc0fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.37Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29918146_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/7db89426ed662c97eb9bdac9ecd8e7ec.webp"
"MediaSize" => 54274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-7db89426ed662c97eb9bdac9ecd8e7ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.35Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29918146_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/ae2ea2f7c74a1b9338ed0b1e4ef0841c.webp"
"MediaSize" => 59479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-ae2ea2f7c74a1b9338ed0b1e4ef0841c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:04.38Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29918146_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/33562f39b338f3c8d21609432be32238.webp"
"MediaSize" => 66861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-33562f39b338f3c8d21609432be32238.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:09.81Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29918146_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/f4fa105c768641f7b2ae31646f598ee7.webp"
"MediaSize" => 89828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-f4fa105c768641f7b2ae31646f598ee7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:14.09Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29918146_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/bc716b992bfaf5f2813ed0a3dbd607a7.webp"
"MediaSize" => 58417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-bc716b992bfaf5f2813ed0a3dbd607a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:09.85Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29918146_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918146/203e7aaad44a5eb7a68d3eb969cd3fed.webp"
"MediaSize" => 54194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918146/thumbnail-203e7aaad44a5eb7a68d3eb969cd3fed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141541"
"ResourceRecordKey" => "29918146"
"ModificationTimestamp" => "2026-06-17T20:12:09.8Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918146')"
+"ID": "1541511"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25154
+post_id: "1540478"
+post_author: 1
+"ListingKey": "29915525"
+"ListingId": "NB142100"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:25:05Z"
+"RFModificationTimestamp": "2026-06-17T20:26:52Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 25693.63
+"LivingArea": 1984.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E4R5"
+"UnparsedAddress": "36 Peat Drive, Quispamsis, New Brunswick E2E4R5"
+"Coordinates": array:2 [
0 => -65.960886
1 => 45.406856
]
+"Latitude": 45.406856
+"Longitude": -65.960886
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to Cedar Ridge Park, one of the area's most sought-after neighbourhoods! This spacious split-entry home features a bright eat-in kitchen, inviting living room, three bedrooms, and a full bathroom. Step through the patio doors onto your private deck overlooking a huge, completely secluded backyard! An ideal space for relaxing and entertaining. The lower level provides incredible flexibility with an additional room for an office/guest space, a large family room, laundry area, storage, half bath, and a convenient walk-out access to the attached double car garage. Located within walking distance to shops, restaurants, and everyday amenities, with quick highway access for an easy commute, this home offers the lifestyle you've been looking for. (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-17T15:57:11.334604+00:00"
+"Directions": "Hampton Road to Peat Drive"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Ceramic"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948403"
+"ListOfficeKey": "269605"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "25693.63"
+"ParcelNumber": "00095588"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T15:21:45Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T20:15:09Z"
+"TaxAnnualAmount": "4027.24"
+"WaterSource": array:1 [
0 => "Well"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1661453448"
"RoomType" => "Bedroom"
"ListingId" => "NB142100"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915525"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:09.83Z"
]
1 => array:11 [
"RoomKey" => "1661453449"
"RoomType" => "Bedroom"
"ListingId" => "NB142100"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915525"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:09.83Z"
]
2 => array:11 [
"RoomKey" => "1661453450"
"RoomType" => "Bedroom"
"ListingId" => "NB142100"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915525"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:09.83Z"
]
3 => array:11 [
"RoomKey" => "1661453451"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB142100"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915525"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:09.83Z"
]
4 => array:11 [
"RoomKey" => "1661453452"
"RoomType" => "Living room"
"ListingId" => "NB142100"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915525"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:09.83Z"
]
5 => array:11 [
"RoomKey" => "1661453453"
"RoomType" => "Dining nook"
"ListingId" => "NB142100"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915525"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:09.83Z"
]
6 => array:11 [
"RoomKey" => "1661453454"
"RoomType" => "Kitchen"
"ListingId" => "NB142100"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915525"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:15:09.84Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29915525/36-peat-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1092
+"OriginalEntryTimestamp": "2026-06-17T15:15:37.55Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1242926"
+"ListOfficeNationalAssociationId": "1243995"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29915525_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/5183077ea58775ebc5001461b1aa8e7d.webp"
"MediaSize" => 149539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-5183077ea58775ebc5001461b1aa8e7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.05Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29915525_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/971e79af1d8a4559f40d224bccb67224.webp"
"MediaSize" => 136957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-971e79af1d8a4559f40d224bccb67224.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29915525_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/b03e185196d6167a5936a38bce9a5e8f.webp"
"MediaSize" => 144801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-b03e185196d6167a5936a38bce9a5e8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:42.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29915525_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/ab654ac78ac036e8566f5fc7aeb504ae.webp"
"MediaSize" => 78793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-ab654ac78ac036e8566f5fc7aeb504ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:42.92Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29915525_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/efa619a64b23dedba791a0ffc5d6a8f7.webp"
"MediaSize" => 51825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-efa619a64b23dedba791a0ffc5d6a8f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.72Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29915525_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/5d8f7f826e241b0a2b01583a7487fb03.webp"
"MediaSize" => 56468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-5d8f7f826e241b0a2b01583a7487fb03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.86Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29915525_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/245a622cdaf6845f4fb49b386aed44aa.webp"
"MediaSize" => 51663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-245a622cdaf6845f4fb49b386aed44aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29915525_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/cbfb2dd311c637620b0ad7b5605797be.webp"
"MediaSize" => 45987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-cbfb2dd311c637620b0ad7b5605797be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.08Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29915525_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/b5e47050a77659421ff04fbe63f7aec2.webp"
"MediaSize" => 45498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-b5e47050a77659421ff04fbe63f7aec2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.05Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29915525_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/fc8ffb5a4ab805d8d699a015e828cb8d.webp"
"MediaSize" => 83210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-fc8ffb5a4ab805d8d699a015e828cb8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.79Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29915525_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915525/3c70e850d4ec857ca6eae1537efb06e5.webp"
"MediaSize" => 84900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915525/thumbnail-3c70e850d4ec857ca6eae1537efb06e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142100"
"ResourceRecordKey" => "29915525"
"ModificationTimestamp" => "2026-06-17T15:21:43.09Z"
]
11 => array:13 [
"Order" => 12
…12
]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915525')"
+"ID": "1540478"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25151
+post_id: "1534212"
+post_author: 1
+"ListingKey": "29908826"
+"ListingId": "NB141865"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:50:01Z"
+"RFModificationTimestamp": "2026-06-16T15:17:48Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 1405.0
+"LivingArea": 1744.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E1T8"
+"UnparsedAddress": "24 Yandall Drive, Quispamsis, New Brunswick E2E1T8"
+"Coordinates": array:2 [
0 => -65.988255
1 => 45.422582
]
+"Latitude": 45.422582
+"Longitude": -65.988255
+"YearBuilt": 1979
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Well-Maintained Family Home on a Large Corner Lot Located just off Vincent Road, this well-cared-for one-owner home sits on a spacious corner lot surrounded by mature trees and a beautifully manicured lawn. Offering 3 bedrooms and 2 bathrooms, the property has benefited from numerous upgrades over the years, including updated windows, roof improvements, vinyl siding and the addition of an energy-efficient heat pumps. The main level features a bright eat-in kitchen and comfortable living spaces designed for everyday family living. Downstairs, you'll find a large entertainment area complete with a pool table, a dedicated man cave, a laundry room/ full bathroomproviding excellent flexibility for recreation and guests. Outdoor living is equally impressive, with a wrap-around deck that's perfect for relaxing or entertaining. A storage shed offers additional space for tools and seasonal equipment. Proudly maintained by its original owner, this property combines space, comfort, and pride of ownership in a desirable location. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-16T15:17:36.893226+00:00"
+"Directions": "Gondola Point Road to Vincent Road To Yandall Drive"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1659486"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1405"
+"ParcelNumber": "00450387"
+"PhotosChangeTimestamp": "2026-06-16T13:42:09Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-16T13:42:09Z"
+"TaxAnnualAmount": "2902.73"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29908826/24-yandall-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1144
+"OriginalEntryTimestamp": "2026-06-16T13:42:09.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1167464"
+"ListOfficeNationalAssociationId": "1007064"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908826')"
+"ID": "1534212"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25155
+post_id: "1533780"
+post_author: 1
+"ListingKey": "29902719"
+"ListingId": "NB141815"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:35:15Z"
+"RFModificationTimestamp": "2026-06-15T15:38:50Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 1.62
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E6B1"
+"UnparsedAddress": "42 Lila Court, Quispamsis, New Brunswick E2E6B1"
+"Coordinates": array:2 [
0 => -65.971538
1 => 45.410002
]
+"Latitude": 45.410002
+"Longitude": -65.971538
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 42 Lila Court, a beautifully maintained family home nestled on a quiet court in the heart of Quispamsis. Situated on a private, landscaped lot with mature gardens and a paved driveway, this property offers the perfect combination of comfort, space, and convenience. Step inside to discover a bright and inviting open-concept main level designed for everyday living and entertaining. The spacious kitchen flows seamlessly into the dining and living areas, where large windows fill the home with natural light and create a warm, welcoming atmosphere. Down the hall, you'll find three generously sized bedrooms and a well-appointed full bathroom, providing plenty of room for a growing family. The lower level expands your living space with a large family room, a second full bathroom, and an additional room currently used as a bedroom (window is non-egress), making it ideal for guests, a home office, or hobby space. The unfinished portion of the basement offers exceptional storage and endless possibilities for a gym, workshop, or future development. A convenient walkout provides direct access to the private backyard. Located in one of Quispamsis' most desirable neighbourhoods, close to schools, parks, trails, and everyday amenities, this move-in-ready home offers outstanding value and versatility. If you've been searching for a property that combines space, privacy, and a prime location, 42 Lila Court is one you won't want to miss. Contact your REALTOR® today to arrange your private viewing. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"CreationDate": "2026-06-15T15:38:40.260544+00:00"
+"Directions": "Off Pettingill Rd"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834886"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Treed"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1.62"
+"ParcelNumber": "00254680"
+"PhotosChangeTimestamp": "2026-06-15T12:29:46Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-15T12:29:46Z"
+"TaxAnnualAmount": "3393.81"
+"VirtualTourURLUnbranded": "https://youtu.be/axs9JAZd9ys"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "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/29902719/42-lila-court-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1288
+"OriginalEntryTimestamp": "2026-06-15T12:29:46.38Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1196834"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902719')"
+"ID": "1533780"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25153
+post_id: "1524826"
+post_author: 1
+"ListingKey": "29887615"
+"ListingId": "NB141664"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T13:25:10Z"
+"RFModificationTimestamp": "2026-06-11T15:59:22Z"
+"ListPrice": 484900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 15005.0
+"LivingArea": 2200.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E1B4"
+"UnparsedAddress": "61 Roberts Lane, Quispamsis, New Brunswick E2E1B4"
+"Coordinates": array:2 [
0 => -65.997205
1 => 45.421133
]
+"Latitude": 45.421133
+"Longitude": -65.997205
+"YearBuilt": 1979
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome home to this beautifully maintained split-entry, where thoughtful updates and comfortable living come together effortlessly. Starting with the standout feature, the home's brand new oversized double garage is truly a dream that has all the tech bells and whistles, complete with a convenient additional mini garage door that provides easy access to the backyard. Stepping outside, the fully fenced in backyard offer plenty of space to relax, entertain, and enjoy the outdoors, complete with a hot tub and a peaceful setting you'll appreciate year-round. Inside, the main level is bright, welcoming, and designed for everyday living. The kitchen flows seamlessly into the dining area, creating a natural gathering space for family meals and entertaining. The sun-filled living room adds warmth and charm, while three generously sized bedrooms provide plenty of room for the whole family. Downstairs, you'll find even more versatile living space with a cozy family room, a fourth bedroom, a full bathroom, and ample storage to keep everything organized. With its exceptional condition, dream garage, private backyard, and family-friendly layout, this home offers the perfect blend of comfort, functionality, and lifestyle. All that's left to do is move in and enjoy. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-11T15:59:08.896325+00:00"
+"Directions": "Neighbourhood off Vincent Rd. Turn onto Grant Dr., left on Boyd Ave, right on Roberts Lane"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2134877"
+"ListOfficeKey": "279450"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Golf course/parkland"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "15005"
+"ParcelNumber": "30026983"
+"ParkingFeatures": array:4 [
0 => "Attached Garage"
1 => "Garage"
2 => "Garage"
3 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-11T13:15:50Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-11T13:15:49Z"
+"TaxAnnualAmount": "4114.23"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=RBVwqidxL5B&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29887615/61-roberts-lane-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1144
+"OriginalEntryTimestamp": "2026-06-11T13:15:49.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1387205"
+"ListOfficeNationalAssociationId": "1304536"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887615')"
+"ID": "1524826"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25148
+post_id: "1518138"
+post_author: 1
+"ListingKey": "29881880"
+"ListingId": "NB141163"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T18:50:06Z"
+"RFModificationTimestamp": "2026-06-14T18:51:28Z"
+"ListPrice": 534900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.34
+"LivingArea": 2632.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E4Y5"
+"UnparsedAddress": "16 Cove Crescent, Rothesay, New Brunswick E2E4Y5"
+"Coordinates": array:2 [
0 => -65.995719
1 => 45.411295
]
+"Latitude": 45.411295
+"Longitude": -65.995719
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 16 Cove Crescent, a well-maintained 2 storey home in Rothesay's West Beach Estates neighbourhood. This property offers a great combination of indoor and outdoor living, highlighted by an in-ground heated pool and a backyard designed for enjoying the summer months us northerners long for. The main level features a traditional layout with a bright living room, dining room, kitchen, family room with a propane stove, and a convenient laundry room. Upstairs you'll find three bedrooms, including a primary suite with a walk-in closet and ensuite bath. The finished walkout basement adds valuable living space with a large family room, an additional rec room, storage closet, and an unfinished utility/storage area. A whole-home Generac backup generator system provides added peace of mind year-round. Located just minutes from the Kennebecasis River, Jordan Miller Park, and some of the area's most sought-after schools, this is an excellent opportunity to settle into one of Rothesay's most established family neighbourhoods. (id:62783)"
+"BathroomsPartial": 1
+"CreationDate": "2026-06-10T22:27:47.901501+00:00"
+"Directions": "Gondola Point Rd turn onto Frances Ave, Left onto Beach Dr, Left on Cove."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Ceramic"
1 => "Vinyl"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2008759"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.34"
+"ParcelNumber": "30103493"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T15:15:25Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-14T18:43:05Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "5176.27"
+"VirtualTourURLUnbranded": "https://youtu.be/v0jOZjZWEoU"
+"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/29881880/16-cove-crescent-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1652
+"OriginalEntryTimestamp": "2026-06-10T15:15:25.35Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1290669"
+"ListOfficeNationalAssociationId": "1007064"
+"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('29881880')"
+"ID": "1518138"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1518139"
+post_author: 1
+"ListingKey": "29881877"
+"ListingId": "NB141480"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T15:25:10Z"
+"RFModificationTimestamp": "2026-06-10T22:27:20Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 12507.66
+"LivingArea": 2800.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E2V2"
+"UnparsedAddress": "108 Winchester Drive, Quispamsis, New Brunswick E2E2V2"
+"Coordinates": array:2 [
0 => -65.976172
1 => 45.420439
]
+"Latitude": 45.420439
+"Longitude": -65.976172
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Beautiful four-level home located in a sought-after area of Quispamsis. This home offers a spacious entryway that opens into a bright and inviting living room, along with a large kitchen, dining area, and breakfast nook with access to the rear deck. Just a few steps up, youll find three generously sized bedrooms and a full bath. The lower level features a cozy family room, an additional bedroom, a bathroom, and a laundry room with walkout access to the attached double car garage. The lowest level is also finished, offering even more open space and plenty of square footage-perfect for a variety of uses. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "3 Level"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-10T22:27:18.796442+00:00"
+"Directions": "Pettingill --> Kensington --> Winchester"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Carpeted"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1816336"
+"ListOfficeKey": "94518"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "12507.66"
+"ParcelNumber": "30069710"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T15:15:22Z"
+"PhotosCount": 23
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T15:15:22Z"
+"TaxAnnualAmount": "4802.49"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29881877/108-winchester-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2026-06-10T15:15:22.02Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1192694"
+"ListOfficeNationalAssociationId": "1159552"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881877')"
+"ID": "1518139"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25156
+post_id: "1511314"
+post_author: 1
+"ListingKey": "29876341"
+"ListingId": "NB141470"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T19:20:06Z"
+"RFModificationTimestamp": "2026-06-14T19:20:53Z"
+"ListPrice": 325000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 17534.0
+"LivingArea": 2184.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E3H6"
+"UnparsedAddress": "13 Iona Avenue, Rothesay, New Brunswick E2E3H6"
+"Coordinates": array:2 [
0 => -65.981503
1 => 45.393397
]
+"Latitude": 45.393397
+"Longitude": -65.981503
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Nestled on a highly desirable and exceptionally private lot, this unique two-storey home offers incredible flexibility and space, all within walking distance of Rothesay hub, several schools, and just five minutes from the highway. With 6 bedrooms and 3 full bathrooms in a multi-level floor plan, this home can easily adapt to a variety of living arrangements, whether you're seeking a spacious single-family home, in-family living setup, or potential duplex opportunity. Step inside to a generous front entryway that opens into a bright and inviting living room filled with natural light. The functional kitchen offers ample cabinetry and counter space, along with convenient access to the back deckperfect for entertaining or enjoying your morning coffee. This level also features two bedrooms and a full bathroom. Upstairs, you'll find three generously sized bedrooms, including one currently used as a home office. The spacious primary suite features abundant windows, a large walk-in closet, and a convenient three-quarter ensuite bath. The unfinished basement provides additional possibilities, including space for a future bedroom or expanded living area. Laundry facilities and the hot water tank are also located on this level. Outside, the impressive backyard is a true retreat. The large rear deck overlooks a beautiful patio area with a fire pit, while the yard offers a perfect balance of sun and shade. A storage shed provides extra outdoor storage, and the exceptionally private setting creates a peaceful atmosphere rarely found so close to amenities. Completing the property is a two-car insulated and wired garage, adding both convenience and functionality to this surprisingly spacious home filled with opportunity. This is a fantastic opportunity in a very desirable Rothesay location! (id:62650)"
+"CreationDate": "2026-06-09T19:18:35.135252+00:00"
+"Directions": "Hampton RD to Iona"
+"ExteriorFeatures": array:1 [
0 => "Cedar shingles"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Radiant heat"
1 => "Forced air"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1835969"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "17534"
+"ParcelNumber": "00246272"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T19:15:41Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-14T19:14:27Z"
+"Stories": "2.5"
+"TaxAnnualAmount": "3759"
+"VirtualTourURLUnbranded": "https://youtu.be/XUldh4UQtWc"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29876341/13-iona-avenue-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2184
+"OriginalEntryTimestamp": "2026-06-09T16:31:51.79Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1197046"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876341')"
+"ID": "1511314"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25157
+post_id: "1513454"
+post_author: 1
+"ListingKey": "29874853"
+"ListingId": "NB141256"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T16:10:35Z"
+"RFModificationTimestamp": "2026-06-09T16:15:53Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 20666.71
+"LivingArea": 2628.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E6B7"
+"UnparsedAddress": "50 Monaco Drive, Rothesay, New Brunswick E2E6B7"
+"Coordinates": array:2 [
0 => -65.983298
1 => 45.404513
]
+"Latitude": 45.404513
+"Longitude": -65.983298
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "This beautifully appointed 2-storey family home, offering over 2,600 sq. ft. of thoughtfully designed living space, is situated on a generous 0.47-acre lot in one of Rothesay's most desirable neighbourhoods. Ideally located close to shopping, recreation facilities, and excellent schools, this property combines comfort, style, and convenience. Inside, you'll find 4 spacious bedrooms and 3½ bathrooms, providing plenty of room for a growing family or those who love to entertain. This home has been professionally decorated by Tuck Studios and was featured in one of their publications, showcasing its timeless design and attention to detail. The fully finished basement adds exceptional versatility with a non-conforming bedroom, full bathroom, and a large recreation room complete with a wet baran ideal space for entertaining guests, a home theatre, or extended family living. The double attached garage offers convenient interior access to the basement storage/workshop area and also includes a man door exiting to the side yard. Step outside and you'll appreciate the same level of meticulous care and pride of ownership that is evident throughout the home. The private backyard creates a peaceful retreat, featuring a relaxing fire pit area and a separate storage shed. Enjoy your morning coffee on the charming front veranda, then unwind at the end of the day on the back deck, overlooking the beautifully maintained outdoor space. This exceptional property offers you the perfect balance of elegant living, functional space, and an outstanding location. A rare opportunity to own a gorgeous home in the heart of Rothesayone that is ready for its next family to enjoy. (id:62650)"
+"BathroomsPartial": 1
+"CreationDate": "2026-06-09T13:33:14.133222+00:00"
+"Directions": "Off Hampton Rd to Oakville acres"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Baseboard heaters"
1 => "Stove"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422709"
+"ListOfficeKey": "51409"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Golf course/parkland"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "20666.71"
+"ParcelNumber": "30078307"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T16:00:56Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-09T16:00:56Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "5010.94"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=v5nsTrnEbPn"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29874853/50-monaco-drive-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2250922"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1749830"
+"CoListOfficeKey": "51409"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "51409"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1834
+"OriginalEntryTimestamp": "2026-06-09T13:14:43.98Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1086881"
+"ListOfficeNationalAssociationId": "1007070"
+"CoListAgentNationalAssociationId": "1489852"
+"CoListAgentNationalAssociationId2": "1181555"
+"CoListOfficeNationalAssociationId": "1007070"
+"CoListOfficeNationalAssociationId2": "1007070"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874853')"
+"ID": "1513454"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 25
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]