array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29831612 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1479835"
+post_author: 1
+"ListingKey": "29831612"
+"ListingId": "NB138825"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T19:50:28Z"
+"RFModificationTimestamp": "2026-06-01T19:55:13Z"
+"ListPrice": 539000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 19225.0
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E4V5"
+"UnparsedAddress": "412 Hampton Road, Quispamsis, New Brunswick E2E4V5"
+"Coordinates": array:2 [
0 => -65.950189
1 => 45.423508
]
+"Latitude": 45.423508
+"Longitude": -65.950189
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Experience the ease of one-level living without compromising the privacy & independence of a detached home. Offering an exceptional low-maintenance lifestyle on your own beautifully landscaped lot, this immaculate bungalow is a wonderful alternative to garden home living; no shared walls, no cramped spaces, just comfort, privacy & room to enjoy life. With a generous 1400 sq ft open-concept floor plan, a newer built 24x24 detached garage & heated separate studio, this property is perfectly suited for empty nesters, single professionals, or anyone seeking the convenience of stair-free living in a peaceful setting.Surrounded by mature trees & attractive gardens, the property was created for outdoor enjoyment with a sunny deck, firepit area & partially fenced yard that could easily be fully enclosed for pets. Inside, comfort & efficiency go hand in hand. Home features in-floor radiant heat complemented by 2 ductless heat pumps providing both heating & cooling options while helping to keep utility costs low. Beautifully appointed kitchen showcases rich cherry cabinetry, granite countertops & a welcoming island where family & guests can gather-open to bright & airy great room this area is filled with natural light from tall south-facing windows overlooking the deck and wooded backyard. The charming standalone 14x12 studio offers endless flexibility; ideal as a home office, artists studio, fitness room or quiet creative space. The home offers three comfortable bedrooms, including a spacious primary suite with a beautifully refreshed ensuite bath plus garden door access to a warm, private sundeck. The second & third bedrooms are generously sized, with one currently serving as a peaceful den. Thoughtfully designed, highly maintained (roof shingles 2024) for those seeking quality; a love of the outdoors where your yard is your sancutary & perfect jump off location for walking & biking! Quispamsis is vibrant & active with trail systems, beaches & parks all close by! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-01T13:50:23.598850+00:00"
+"Directions": "On Hampton Road, past Milligan Drive"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Carpeted"
]
+"FoundationDetails": array:2 [
0 => "Concrete Perimeter"
1 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Radiant heat"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422684"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "19225"
+"ParcelNumber": "30209498"
+"ParkingFeatures": array:4 [
0 => "Detached Garage"
1 => "Garage"
2 => "Garage"
3 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-01T19:21:25Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-01T19:43:20Z"
+"TaxAnnualAmount": "6122.73"
+"VirtualTourURLUnbranded": "https://youtu.be/8eUIyKYdT6Y"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1648834711"
"RoomType" => "Other"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "12' x 14'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.23Z"
]
1 => array:11 [
"RoomKey" => "1648834712"
"RoomType" => "Laundry room"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "5'7'' x 10'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.23Z"
]
2 => array:11 [
"RoomKey" => "1648834713"
"RoomType" => "Bedroom"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.23Z"
]
3 => array:11 [
"RoomKey" => "1648834714"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.23Z"
]
4 => array:11 [
"RoomKey" => "1648834715"
"RoomType" => "Bedroom"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.23Z"
]
5 => array:11 [
"RoomKey" => "1648834716"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.24Z"
]
6 => array:11 [
"RoomKey" => "1648834717"
"RoomType" => "Dining room"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.24Z"
]
7 => array:11 [
"RoomKey" => "1648834718"
"RoomType" => "Kitchen"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 13'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.24Z"
]
8 => array:11 [
"RoomKey" => "1648834719"
"RoomType" => "Great room"
"ListingId" => "NB138825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29831612"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-01T19:43:20.24Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29831612/412-hampton-road-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1400
+"OriginalEntryTimestamp": "2026-06-01T13:00:00.5Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1085897"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29831612_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/8c1fa800d093f3b6f324d9368d35b7cd.webp"
"MediaSize" => 208535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-8c1fa800d093f3b6f324d9368d35b7cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Tucked in beautifully"
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:38.52Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29831612_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/c26705a5e8024ae1d650f3e83c9b9fd5.webp"
"MediaSize" => 195297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-c26705a5e8024ae1d650f3e83c9b9fd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mature lot enjoyed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.71Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29831612_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/d8ccbcd6a9f6d91a23e0b989941a7fdf.webp"
"MediaSize" => 191025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-d8ccbcd6a9f6d91a23e0b989941a7fdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Attractive one level bungalow"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.18Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29831612_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/2e583fae578bf6eb032bb7222eaa9e93.webp"
"MediaSize" => 70840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-2e583fae578bf6eb032bb7222eaa9e93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer to greet guests"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29831612_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/fee83f520a6dbd3c308d5a954da79ec1.webp"
"MediaSize" => 100386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-fee83f520a6dbd3c308d5a954da79ec1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcoming floorplan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29831612_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/3c688c6fa53fd2ea431248b7e3f1d2cd.webp"
"MediaSize" => 97114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-3c688c6fa53fd2ea431248b7e3f1d2cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rooms with a view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:33.67Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29831612_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/3b800457d32ccc9e26c122b663a0b418.webp"
"MediaSize" => 113742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-3b800457d32ccc9e26c122b663a0b418.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gather 'round....."
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:33.69Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29831612_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/be7456d3301124d8e44e0c669efabcf7.webp"
"MediaSize" => 94231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-be7456d3301124d8e44e0c669efabcf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bay window and garden door at deck level-no stairs ideal."
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.7Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29831612_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/cb5d2f1a5674d64582df786128335236.webp"
"MediaSize" => 107740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-cb5d2f1a5674d64582df786128335236.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "How comfortable with those backyard views!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.2Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29831612_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/fe94e0f904c087af5c5dd4ff0d18b93d.webp"
"MediaSize" => 89425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-fe94e0f904c087af5c5dd4ff0d18b93d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cherry cabinetry and granite tops..appliances only 3 years old"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.7Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29831612_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/35ec127ac79796c9a461056dbbb52261.webp"
"MediaSize" => 102092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-35ec127ac79796c9a461056dbbb52261.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lots of prep area ...eating at home a joy"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.7Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29831612_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/313d6174ce8273723097744359e0465f.webp"
"MediaSize" => 91874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-313d6174ce8273723097744359e0465f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bringing the outdoors in ..so airy and bright"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.19Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29831612_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/95769f3190d54d7fcf5e435e8d91f548.webp"
"MediaSize" => 108603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-95769f3190d54d7fcf5e435e8d91f548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floorplan so easy to live in"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.18Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29831612_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/cb07cb2ecca966a32837336abecf5e43.webp"
"MediaSize" => 90321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-cb07cb2ecca966a32837336abecf5e43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Den currently or 3rd bedroom or office"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.17Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29831612_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/5044cca27ffdcde26373d7720f9b5584.webp"
"MediaSize" => 100470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-5044cca27ffdcde26373d7720f9b5584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd bedroom with pretty fron views"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.18Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29831612_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/88a7b5b437da69240adad1963a179641.webp"
"MediaSize" => 80457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-88a7b5b437da69240adad1963a179641.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:33.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29831612_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/7abd4d81f2490e47eb6fc403476ee242.webp"
"MediaSize" => 80301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-7abd4d81f2490e47eb6fc403476ee242.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath sparkles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.17Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29831612_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/64add0eeec74041f481dddce94ef4522.webp"
"MediaSize" => 87444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-64add0eeec74041f481dddce94ef4522.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wake up to sound of the birds ,walkout to private deck ,heat pump cooling appreciated inn hot months."
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29831612_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/bf2ac39e8566019291700f311be039f3.webp"
"MediaSize" => 86343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-bf2ac39e8566019291700f311be039f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary with built in for tv, books, etc"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:33.67Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29831612_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/ef06e95f293f52d38a9718b2e0031a50.webp"
"MediaSize" => 66616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-ef06e95f293f52d38a9718b2e0031a50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cherry cabintry - plenty of storage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:33.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29831612_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/baefa4151c4b914d858b6bd54fbf3a69.webp"
"MediaSize" => 71820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-baefa4151c4b914d858b6bd54fbf3a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Immaculate ensuite in primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.17Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29831612_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/470d8fd1ed0c18e8460addd23a1b8409.webp"
"MediaSize" => 61443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-470d8fd1ed0c18e8460addd23a1b8409.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Step saving main floor laundry and utility"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.17Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29831612_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/2dca491bd9a4f7fd9ff1f325de6308cb.webp"
"MediaSize" => 202733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-2dca491bd9a4f7fd9ff1f325de6308cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dream garage 24x24"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.72Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29831612_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/65eb0eb2c221ab0dd101327c312892de.webp"
"MediaSize" => 132768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-65eb0eb2c221ab0dd101327c312892de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "9ft doors-space for workbench"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.2Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29831612_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/a5a5a65970e7f1f588b020978b58e42e.webp"
"MediaSize" => 153279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-a5a5a65970e7f1f588b020978b58e42e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Heated deckside studio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.7Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29831612_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/9d7f68898d29d80632a8bf67d1b8624e.webp"
"MediaSize" => 190212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-9d7f68898d29d80632a8bf67d1b8624e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spring coming -a fenced veggy garden plot"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.18Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29831612_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/1209766bd20fe09ddf4e93185711746e.webp"
"MediaSize" => 153109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-1209766bd20fe09ddf4e93185711746e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Natural light abundance in studio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.17Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29831612_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/12f137dd7322e33076655b943295b9c0.webp"
"MediaSize" => 169431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-12f137dd7322e33076655b943295b9c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sit and listen to nature."
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:33.68Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29831612_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/835ef1fc2b39b8d190d7c742d536671f.webp"
"MediaSize" => 96893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-835ef1fc2b39b8d190d7c742d536671f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior of studio -3 windows for natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.72Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29831612_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/aea3ca941c47893ff7b0a64696fae36c.webp"
"MediaSize" => 101652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-aea3ca941c47893ff7b0a64696fae36c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Many uses can be enjoyed inn this heated area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.72Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29831612_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/37726a6530159e7886e674feb16a2544.webp"
"MediaSize" => 208804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-37726a6530159e7886e674feb16a2544.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spring time and greening up quickly"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.17Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29831612_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/9a30247f2f0f6d3cbcd5cb740fc89c55.webp"
"MediaSize" => 167626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-9a30247f2f0f6d3cbcd5cb740fc89c55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sidewalk out your front door ..stroll down to center of town ."
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:33.67Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29831612_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/4c378b5a5225a17b4049ff6ee99f59d6.webp"
"MediaSize" => 160905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-4c378b5a5225a17b4049ff6ee99f59d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stratigically designed driveway for safe exit."
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.7Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29831612_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/fb4f8a98d63bd58bdc5f308eef5f0a91.webp"
"MediaSize" => 273549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-fb4f8a98d63bd58bdc5f308eef5f0a91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Low maintenace beautiful shrubs in your forested backyard."
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:38.97Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29831612_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/dc45f8645f4073f6b54f13f48ec2991f.webp"
"MediaSize" => 259468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-dc45f8645f4073f6b54f13f48ec2991f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Shade gardens delightful"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:38.52Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29831612_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/7fe4903cf592f6ad8f84c0fc24f16dfa.webp"
"MediaSize" => 303254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-7fe4903cf592f6ad8f84c0fc24f16dfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Partial fencing now...but you could complete ."
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:37.12Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29831612_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/863c69e32088f24b944a60effde6aefa.webp"
"MediaSize" => 284039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-863c69e32088f24b944a60effde6aefa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front driveway gardens"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:38.98Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29831612_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/c166f6823faf88ab598587c9da00d91c.webp"
"MediaSize" => 274106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-c166f6823faf88ab598587c9da00d91c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Such attractive spaces"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:38.99Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29831612_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/c54877fd6ab2b987c6a795f2c4535730.webp"
"MediaSize" => 26740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-c54877fd6ab2b987c6a795f2c4535730.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.72Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29831612_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/943a7aa6e1739c1ca879227b55ed6b0c.webp"
"MediaSize" => 266416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-943a7aa6e1739c1ca879227b55ed6b0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Well planned"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.22Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29831612_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/2195fbda471a148d124bb081f97bf6dd.webp"
"MediaSize" => 263514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-2195fbda471a148d124bb081f97bf6dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.21Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29831612_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/2e4b54b1e61bd0f039009b5d60875449.webp"
"MediaSize" => 202062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-2e4b54b1e61bd0f039009b5d60875449.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private, easy and enjoyable"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T13:01:34.7Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29831612_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/c529bb4a786131037efdd6874de5e0d4.webp"
"MediaSize" => 114235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-c529bb4a786131037efdd6874de5e0d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T19:21:24.31Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29831612_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831612/0499378ad6f9c73206ba1045a2f5f217.webp"
"MediaSize" => 68113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831612/thumbnail-0499378ad6f9c73206ba1045a2f5f217.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138825"
"ResourceRecordKey" => "29831612"
"ModificationTimestamp" => "2026-06-01T19:21:24.3Z"
]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29831612')"
+"ID": "1479835"
}
]
+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 51407" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24810
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1422684" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24783
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29831612'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25128
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29831612'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25144
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29831612' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-65.950189 45.423508)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25217
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25191
+post_id: "1530010"
+post_author: 1
+"ListingKey": "29902842"
+"ListingId": "NB141611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T13:40:09Z"
+"RFModificationTimestamp": "2026-06-15T13:47:58Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 52337.0
+"LivingArea": 1683.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E4V5"
+"UnparsedAddress": "416 Hampton Road, Quispamsis, New Brunswick E2E4V5"
+"Coordinates": array:2 [
0 => -65.94985
1 => 45.42391
]
+"Latitude": 45.42391
+"Longitude": -65.94985
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Looking for space, flexibility, and a garage that can handle all your projects, toys, and equipment? This unique 1.2-acre property offers the perfect blend of comfortable family living and exceptional outdoor functionality. The 1.5-storey home features a practical and flexible floor plan with a spacious kitchen, inviting living room, full 4-piece bathroom, and an additional main-floor room that can easily serve as a formal dining room, home office, family room, or playroom. Upstairs, the original four-bedroom layout has been thoughtfully reconfigured into three bedrooms, creating a generously sized primary bedroom along with two additional bedrooms. The home offers year-round comfort with an updated propane furnace and a mini-split heat pump providing efficient heating and cooling. The concrete foundation basement offers excellent storage space and includes a wood stove for an additional heat source. Outside is where this property truly shines. The current owner has invested significant time and effort into developing the grounds, featuring custom rock walls, attractive landscaping, fencing, and extensive level parking areas with room for vehicles, trailers, RVs, boats, and recreational equipment. A heated and insulated carport provides additional sheltered workspace or parking. The standout feature is the impressive 58 x 24 insulated and heated garage; ideal for hobbyists, contractors, mechanics, or anyone needing serious storage and workspace. Adding even more functionality is a 16-foot shed roof running the full length of the garage, providing substantial covered storage for equipment, vehicles, firewood, or seasonal items. Whether youre searching for a family home with room to grow, a property that accommodates your hobbies and business needs, or simply a place with exceptional parking, storage, and workshop space, this versatile property is well worth a closer look. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-15T13:47:49.124577+00:00"
+"Directions": "On Hampton Road across from Cannon Road."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422717"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Visual exposure"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "52337"
+"ParcelNumber": "30209480"
+"ParkingFeatures": array:4 [
0 => "Detached Garage"
1 => "Garage"
2 => "Carport"
3 => "Heated Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T13:15:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-15T13:32:14Z"
+"TaxAnnualAmount": "4916.74"
+"VirtualTourURLUnbranded": "https://youtu.be/Fmf2kYL2HyU"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1659805799"
"RoomType" => "Bedroom"
"ListingId" => "NB141611"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29902842"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T13:32:14.45Z"
]
1 => array:11 [
"RoomKey" => "1659805800"
"RoomType" => "Bedroom"
"ListingId" => "NB141611"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29902842"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T13:32:14.45Z"
]
2 => array:11 [
"RoomKey" => "1659805801"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141611"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29902842"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T13:32:14.45Z"
]
3 => array:11 [
"RoomKey" => "1659805802"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB141611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902842"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T13:32:14.45Z"
]
4 => array:11 [
"RoomKey" => "1659805803"
"RoomType" => "Living room/Dining room"
"ListingId" => "NB141611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902842"
"RoomLength" => null
"RoomDimensions" => "14' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T13:32:14.45Z"
]
5 => array:11 [
"RoomKey" => "1659805804"
"RoomType" => "Living room"
"ListingId" => "NB141611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902842"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T13:32:14.45Z"
]
6 => array:11 [
"RoomKey" => "1659805805"
"RoomType" => "Kitchen"
"ListingId" => "NB141611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902842"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 18'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T13:32:14.45Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29902842/416-hampton-road-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1683
+"OriginalEntryTimestamp": "2026-06-15T13:15:30.37Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1086880"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29902842_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/dcacd2a164c8e8dc0e68d561fab8d4cf.webp"
"MediaSize" => 150458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-dcacd2a164c8e8dc0e68d561fab8d4cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29902842_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/d0e93fbaf567936f06d1c768dcb84ea9.webp"
"MediaSize" => 158823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-d0e93fbaf567936f06d1c768dcb84ea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29902842_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/9e83c4e367a93e9297ab350268e4d65e.webp"
"MediaSize" => 140601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-9e83c4e367a93e9297ab350268e4d65e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29902842_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/74a405111d52d64dabc80499bd5c8749.webp"
"MediaSize" => 101242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-74a405111d52d64dabc80499bd5c8749.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29902842_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/41763ff12eaef0b8126c9bb487956793.webp"
"MediaSize" => 140990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-41763ff12eaef0b8126c9bb487956793.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29902842_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/09ad74bae72bf074d0bde25a8218316a.webp"
"MediaSize" => 66170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-09ad74bae72bf074d0bde25a8218316a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29902842_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/2190ba383b5198b25b9cdb2202af74ac.webp"
"MediaSize" => 90625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-2190ba383b5198b25b9cdb2202af74ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29902842_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/a7d0129164b6083611c8a34bb8793026.webp"
"MediaSize" => 100130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-a7d0129164b6083611c8a34bb8793026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29902842_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/b4eb2050790dd65e93a883d3cdba1d51.webp"
"MediaSize" => 98544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-b4eb2050790dd65e93a883d3cdba1d51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29902842_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/7d7b964c737fae63cd8fea53c2762bf4.webp"
"MediaSize" => 87657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-7d7b964c737fae63cd8fea53c2762bf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29902842_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/e6d6a38dd15dc148a06e6c1b7ba0e35c.webp"
"MediaSize" => 85980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-e6d6a38dd15dc148a06e6c1b7ba0e35c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29902842_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/5e2e2a64eecb5e53c9a65f658b689e24.webp"
"MediaSize" => 85579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-5e2e2a64eecb5e53c9a65f658b689e24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29902842_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/ee60de542be4c73d49c25188dd521986.webp"
"MediaSize" => 87034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-ee60de542be4c73d49c25188dd521986.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29902842_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/4a975239d40cbcb88f55bbc291eb465b.webp"
"MediaSize" => 86717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-4a975239d40cbcb88f55bbc291eb465b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29902842_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/e2c9326ebebf9d425e7e582c37d6bc65.webp"
"MediaSize" => 71765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-e2c9326ebebf9d425e7e582c37d6bc65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29902842_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/a34cfb4ec16f531b63376c0324a7cfbf.webp"
"MediaSize" => 62051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-a34cfb4ec16f531b63376c0324a7cfbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29902842_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/b69cb82d8f98ab7309a57846ba9fcc79.webp"
"MediaSize" => 49507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-b69cb82d8f98ab7309a57846ba9fcc79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29902842_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/fa26c69e7c706568e574848f8455c02e.webp"
"MediaSize" => 43487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-fa26c69e7c706568e574848f8455c02e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29902842_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/d66e9391476fbb0522916165af5cb2df.webp"
"MediaSize" => 72882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-d66e9391476fbb0522916165af5cb2df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29902842_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/553cf78fd1fa0bc6d70208da0873c891.webp"
"MediaSize" => 59375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-553cf78fd1fa0bc6d70208da0873c891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29902842_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/301cc72ca26dcc322b7f6b073e990138.webp"
"MediaSize" => 110229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-301cc72ca26dcc322b7f6b073e990138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29902842_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/99aca5f7ae2d563fc82fa407683fc222.webp"
"MediaSize" => 101115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-99aca5f7ae2d563fc82fa407683fc222.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29902842_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/d8fa1efc1c4aaea939c733bcfed0ab6f.webp"
"MediaSize" => 128862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-d8fa1efc1c4aaea939c733bcfed0ab6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29902842_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/25f2b9c656d38828cfa8906cbd4ce30e.webp"
"MediaSize" => 110868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-25f2b9c656d38828cfa8906cbd4ce30e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29902842_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/a574d4919893a1d7ba16fd57967a02e4.webp"
"MediaSize" => 129156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-a574d4919893a1d7ba16fd57967a02e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29902842_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/ad5ce64c27d150322d502e4cea3db5b7.webp"
"MediaSize" => 157175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-ad5ce64c27d150322d502e4cea3db5b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29902842_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/027bf3c4d9ad73974e1a99ebf40bf146.webp"
"MediaSize" => 116451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-027bf3c4d9ad73974e1a99ebf40bf146.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29902842_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/54dd86ebcc21fd19a2f66d8d1fecac1d.webp"
"MediaSize" => 149000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-54dd86ebcc21fd19a2f66d8d1fecac1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29902842_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/53a1218b16057b7901298feed1907d2a.webp"
"MediaSize" => 173267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-53a1218b16057b7901298feed1907d2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29902842_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/6999273be7fa2ffc7d887368830f97cd.webp"
"MediaSize" => 199430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-6999273be7fa2ffc7d887368830f97cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141611"
"ResourceRecordKey" => "29902842"
"ModificationTimestamp" => "2026-06-15T13:15:30.37Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29902842_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902842/6f3aa12d5bfdb0d88b5b63294ab79ee3.webp"
"MediaSize" => 124851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902842/thumbnail-6f3aa12d5bfdb0d88b5b63294ab79ee3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902842')"
+"ID": "1530010"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1524827"
+post_author: 1
+"ListingKey": "29875074"
+"ListingId": "NB141152"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T14:11:01Z"
+"RFModificationTimestamp": "2026-06-09T17:30:35Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 15494.0
+"LivingArea": 2350.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0K4"
+"UnparsedAddress": "2 Luxor Court, Quispamsis, New Brunswick E2E0K4"
+"Coordinates": array:2 [
0 => -65.965316
1 => 45.429843
]
+"Latitude": 45.429843
+"Longitude": -65.965316
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to Woodleigh Park/Cambridge Estates, one of Quispamsis most sought after family neighbourhoods! Perfectly situated within walking distance to Chris Saunders Elementary, Quispamsis Middle School, École des Pionniers and The Woods - this beautifully maintained single family or 2-family bungalow offers the ideal combination of comfort, convenience and versatility. Perfect for a young family, starter, downsize or just wanting some extra income from the basement rental unit. Lovingly cared for over the years, the property is in excellent condition and ready for its next owners. The bright and inviting main level offers an open concept kitchen, dining and living area highlighted by cathedral ceilings and a newly installed mini-split heat pump for year round comfort. 3 spacious bedrooms and a full bath complete the main floor, while the lower level provides a cozy rec room and laundry area for the owners use. The home features a luxurious in-floor heating system throughout the basement level and hot water baseboard system in the upper level. A standout feature of this property is the completely self-contained 2-bedroom lower level apartment. Currently tenant occupied, the suite has been maintained to the same high standard as the main home and offers abundant natural light, heated floors and a mini-split heat pump, its own driveway, patio area and in-unit laundry. Whether youre looking for a mortgage helper, space for extended family, or an investment opportunity, this flexible layout provides exceptional value. Situated on a corner lot with easy highway access and just minutes from shopping, restaurants, recreation facilities and all Quispamsis amenities, this property is a rare opportunity in a prime location. Homes offering this combination of quality, location and income potential dont come along often. (id:62650)"
+"ArchitecturalStyle": array:3 [
0 => "Bungalow"
1 => "Raised bungalow"
2 => "2 Level"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-09T17:30:25.431486+00:00"
+"Directions": "Quispamsis Rd to Cambridge, to Vegas, to Luxor."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Radiant heat"
3 => "Electric"
4 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422717"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "15494"
+"ParcelNumber": "30254635"
+"PhotosChangeTimestamp": "2026-06-09T14:00:19Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-09T14:00:19Z"
+"TaxAnnualAmount": "5191.95"
+"VirtualTourURLUnbranded": "https://youtu.be/TZP9FWwZWx4"
+"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/29875074/2-luxor-court-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1175
+"OriginalEntryTimestamp": "2026-06-09T14:00:19.41Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1086880"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875074')"
+"ID": "1524827"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1528832"
+post_author: 1
+"ListingKey": "29855233"
+"ListingId": "NB141144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T19:20:47Z"
+"RFModificationTimestamp": "2026-06-07T19:37:32Z"
+"ListPrice": 170000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1088.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G1W8"
+"UnparsedAddress": "37 Walnut, Quispamsis, New Brunswick E2G1W8"
+"Coordinates": array:2 [
0 => -65.925291
1 => 45.420606
]
+"Latitude": 45.420606
+"Longitude": -65.925291
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "MARVELOUS MINI! This lovely family home is spacious and tucked away on a quiet court. Close to everything in the valley with a short drive and Saint John is just 15 minutes away too. One level living with 3 bedrooms and 2 baths, vaulted ceilings and a private yard.....this home is a great option for someone who is downsizing or a first time buyer. Great open concept layout. Pad fees of $398 a month include water and sewer. If you are considering a first home....this may be a great option. Heat and lights 12 months average $232.35 .....WOW!! Book your private showing today! (id:62650)"
+"Basement": array:1 [
0 => "Crawl space"
]
+"CreationDate": "2026-06-04T19:47:51.946287+00:00"
+"Directions": "Quispamsis Mini home park.....far end left side.....past orchard onto Walnut"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1818393"
+"ListOfficeKey": "51409"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "PAN05089300"
+"PhotosChangeTimestamp": "2026-06-04T18:51:48Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-07T19:13:25Z"
+"TaxAnnualAmount": "1262.67"
+"VirtualTourURLUnbranded": "https://youtu.be/kqyZFI_e_jo"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29855233/37-walnut-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1088
+"OriginalEntryTimestamp": "2026-06-04T18:46:02.73Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1193084"
+"ListOfficeNationalAssociationId": "1007070"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29855233')"
+"ID": "1528832"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1483180"
+post_author: 1
+"ListingKey": "29831832"
+"ListingId": "NB140554"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T13:10:37Z"
+"RFModificationTimestamp": "2026-06-02T13:15:17Z"
+"ListPrice": 615000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.164
+"LivingArea": 1361.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0Y9"
+"UnparsedAddress": "17 Wetmore Boulevard Unit# 24, Quispamsis, New Brunswick E2E0Y9"
+"Coordinates": array:2 [
0 => -65.970259
1 => 45.417853
]
+"Latitude": 45.417853
+"Longitude": -65.970259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to premium, turnkey living in this brand-new, high-end semi-detached home featuring an attached garage in a highly desirable neighbourhood. Crafted explicitly for buyers seeking an upscale, low-maintenance lifestyle without compromising on visual style; this home is entirely move-in ready. The bright, open-concept layout seamlessly blends daily relaxation with effortless entertaining. This thoughtfully finished home offers two spacious bedrooms and two full bathrooms, highlighted by a private primary retreat complete with its own ensuite and an oversized walk-in closet designed with dressing-room functionality. Outside, the exterior showcases striking modern curb appeal, wrapped in dark vinyl siding and beautifully accented by bold, natural hemlock pillars for a timeless architectural statement. Enjoy true lock-and-leave convenience with low HOA fees of just $150 per month, which fully cover snow removal, driveway plowing, lawn care, grass mowing, and neighbourhood well maintenance. This is a flawless, worry-free option for working professionals, downsizing retirees, or frequent travelers seeking absolute peace of mind. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-01T14:06:20.338567+00:00"
+"Directions": "Hwy 1 to Gondola Point Arterial. 3rd exit on rotary to Alma Lane. Left on Quispamsis Road. Right on Pettingill. Left on Wetmore Blvd."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993846"
+"ListOfficeKey": "279450"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.164"
+"ParcelNumber": "30368666"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T13:01:20Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-02T13:01:20Z"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29831832/17-wetmore-boulevard-unit-24-quispamsis"
+"StructureType": array:1 [
0 => "Garden Home"
]
+"CoListAgentKey": "2042899"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279450"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1361
+"OriginalEntryTimestamp": "2026-06-01T13:45:14.5Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1276894"
+"ListOfficeNationalAssociationId": "1304536"
+"CoListAgentNationalAssociationId": "1318802"
+"CoListOfficeNationalAssociationId": "1304536"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29831832')"
+"ID": "1483180"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+post_id: "1472655"
+post_author: 1
+"ListingKey": "29820063"
+"ListingId": "NB140614"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T18:11:07Z"
+"RFModificationTimestamp": "2026-06-01T18:21:51Z"
+"ListPrice": 325000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 22.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2G1W3"
+"UnparsedAddress": "Downeast Drive, Rothesay, New Brunswick E2G1W3"
+"Coordinates": array:2 [
0 => -65.944531
1 => 45.411168
]
+"Latitude": 45.411168
+"Longitude": -65.944531
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Discover the rare opportunity to own 54 acres of pristine, private landnestled in nature yet only minutes from all the conveniences of Rothesay and Quispamsis. This unique parcel offers the best of both worlds: peaceful seclusion and quick access to top-tier schools, shopping, dining, and recreational amenities. Zoned for a single-family residence due to development restrictions, this property promises lasting privacy and tranquility. Imagine building your dream home tucked away in the woods, surrounded by rolling hills, mature trees, and wildlifeyour very own sanctuary just outside the city. Whether you envision a luxury country estate, a peaceful on or off-grid retreat, or a place to simply breathe and unwind, this expansive property is your blank canvas. Opportunities like this are raredon't miss your chance to create something truly special, just minutes from everything you need. Close to everything: 14 mins to YSJ, 9 minutes to the heart of Rothesay, 19 mins to Uptown Saint John. Details on development restrictions are in the supplements - contact your REALTOR® or Listing REALTOR® for details - Single Family Home can be built in Zone B (see last page of supplements). (id:62783)"
+"CreationDate": "2026-05-28T23:24:16.964647+00:00"
+"Directions": "Highway exit 141 to COMEX Parking Lot. Take adjacent gravel road Downeast Drive past civic number 140 (Quispamsis Wellfield Monitoring Building). Property is the next driveway. Driveway has steel gate."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2148616"
+"ListOfficeKey": "94518"
+"LotSizeDimensions": "22"
+"ParcelNumber": "00243170"
+"PhotosChangeTimestamp": "2026-06-01T18:03:52Z"
+"PhotosCount": 8
+"Sewer": array:1 [
0 => "No sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-01T18:03:52Z"
+"TaxAnnualAmount": "657.28"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=4Y5Kpx5-20Y"
+"WaterSource": array:1 [
0 => "None"
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29820063/downeast-drive-rothesay"
+"CoListAgentKey": "2234898"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "94518"
+"GeocodeManualYN": false
+"OriginalEntryTimestamp": "2026-05-28T19:12:38.57Z"
+"ListAgentNationalAssociationId": "1399601"
+"ListOfficeNationalAssociationId": "1159552"
+"CoListAgentNationalAssociationId": "1472710"
+"CoListOfficeNationalAssociationId": "1159552"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820063')"
+"ID": "1472655"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1472677"
+post_author: 1
+"ListingKey": "29818854"
+"ListingId": "NB140524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T16:20:33Z"
+"RFModificationTimestamp": "2026-05-31T16:31:15Z"
+"ListPrice": 474900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.32
+"LivingArea": 1920.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G2C5"
+"UnparsedAddress": "39 Meteor Drive, Quispamsis, New Brunswick E2G2C5"
+"Coordinates": array:2 [
0 => -65.931183
1 => 45.425783
]
+"Latitude": 45.425783
+"Longitude": -65.931183
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 39 Meteor Drive in Quispamsis, a beautiful two-storey home in a sought-after neighbourhood offering the space, layout, and features many buyers are looking for. The main level features an open kitchen and living area with access to a large back deck and backyard, along with a mudroom entry from the attached garage that includes laundry and a convenient two-piece bathroom. Upstairs offers three bedrooms and a full bathroom, while the finished basement adds flexible additional living space and a three-piece bathroom. A ducted heat pump system provides efficient heating and central air conditioning year-round, with a new outdoor unit installed last year. With an attached garage, large yard, and a well-designed layout across all three levels, this is a solid opportunity in a great Quispamsis neighbourhood. (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Heat Pump"
]
+"CreationDate": "2026-05-28T18:05:17.016702+00:00"
+"Directions": "Gondola Point arterial turn onto Monarch drive straight to stop sign. Continue onto Meteor, home is on your right."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2008759"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.32"
+"ParcelNumber": "30219315"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T17:23:31Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-31T16:13:55Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "5018.7"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=gbguhnsNh7w"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29818854/39-meteor-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1280
+"OriginalEntryTimestamp": "2026-05-28T17:23:31.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1290669"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29818854')"
+"ID": "1472677"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1468053"
+post_author: 1
+"ListingKey": "29810377"
+"ListingId": "NB139353"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T19:20:30Z"
+"RFModificationTimestamp": "2026-05-31T19:21:25Z"
+"ListPrice": 179900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1184.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G1W9"
+"UnparsedAddress": "11 Sitka Lane, Quispamsis, New Brunswick E2G1W9"
+"Coordinates": array:2 [
0 => -65.926623
1 => 45.420307
]
+"Latitude": 45.420307
+"Longitude": -65.926623
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this charming and exceptionally well-maintained Maple Leaf mini home, perfectly situated in the heart of Quispamsis one of the areas most desirable communities. From the moment you arrive, youll appreciate the pride of ownership, beautiful landscaping, and inviting curb appeal this lovely property has to offer. Step inside to discover a bright and spacious open-concept layout designed for comfortable everyday living and effortless entertaining. The oversized living room is filled with natural light, creating a warm and welcoming atmosphere throughout the home. The impressive kitchen is truly the heart of the home, featuring an abundance of cabinetry, a huge center island, and plenty of space for family gatherings and entertaining guests. This home offers three generously sized bedrooms and two full bathrooms, providing plenty of room for family or visitors. The spacious primary bedroom serves as a private retreat, complete with a full ensuite featuring a relaxing corner Jacuzzi tub the perfect place to unwind at the end of the day. Loaded with extras, this home includes two heat pumps (one owned and one rented) for year-round comfort and efficiency, as well as a brand-new metal roof for added value and peace of mind. Outside, youll love the beautifully landscaped gardens that create a peaceful and private outdoor setting to enjoy all season long. Move-in ready and meticulously cared for, this property combines comfort, style, and convenience in an unbeatable location close to amenities, schools, and everything Quispamsis has to offer. Lot rent $399.00mth. A wonderful opportunity you wont want to miss! (id:62650)"
+"AssociationFee": "399"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-27T18:10:25.308687+00:00"
+"Directions": "Parkside to Redwood left to Sitka"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422583"
+"ListOfficeKey": "51409"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "PAN06131168"
+"PhotosChangeTimestamp": "2026-05-27T12:43:35Z"
+"PhotosCount": 50
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-31T19:14:11Z"
+"TaxAnnualAmount": "1544.12"
+"WaterSource": array:2 [
0 => "Well"
1 => "Community Water System"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29810377/11-sitka-lane-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1184
+"OriginalEntryTimestamp": "2026-05-27T12:43:35.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1096117"
+"ListOfficeNationalAssociationId": "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": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29810377')"
+"ID": "1468053"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1462486"
+post_author: 1
+"ListingKey": "29804673"
+"ListingId": "NB140271"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T17:36:08Z"
+"RFModificationTimestamp": "2026-05-31T17:38:09Z"
+"ListPrice": 569900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 11237.52
+"LivingArea": 2791.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0E4"
+"UnparsedAddress": "10 Granite Drive, Quispamsis, New Brunswick E2E0E4"
+"Coordinates": array:2 [
0 => -65.949153
1 => 45.412076
]
+"Latitude": 45.412076
+"Longitude": -65.949153
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Located in a very popular, central Quispamsis neighbourhood, this stunning two-storey home offers space and a layout designed for family living! Featuring 3+1 bedrooms and 4 bathrooms, this home has room for everyone. The bright open concept kitchen and family room create the heart of the home. The main floor also has a designated laundry area, half bath and a separate living room and dining room providing additional space for entertaining or relaxing. Upstairs has two bedrooms, a full bath and a large primary suite with a spacious walk-in closet and a large four piece ensuite bath. The fully finished, walk out basement adds even more flexibility with extra living space, an additional bedroom, and bathroom. Outside, enjoy the convenience of a double car garage and all the benefits of living in one of the areas most desirable neighbourhoods. A fantastic opportunity to own a beautiful family home in Cedar Ridge Park! (id:62650)"
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-26T15:41:51.708465+00:00"
+"Directions": "Hampton Road to Autumn to Summer Court/Fairholme to Granite OR Millennium Drive to Concorde to Granite"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948403"
+"ListOfficeKey": "269605"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "11237.52"
+"ParcelNumber": "30239198"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-26T13:29:58Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-31T17:13:34Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "5819.54"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29804673/10-granite-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1812
+"OriginalEntryTimestamp": "2026-05-26T13:29:58.03Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1242926"
+"ListOfficeNationalAssociationId": "1243995"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29804673')"
+"ID": "1462486"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1438357"
+post_author: 1
+"ListingKey": "29770471"
+"ListingId": "NB139524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-24T17:26:07Z"
+"RFModificationTimestamp": "2026-05-24T17:30:07Z"
+"ListPrice": 164900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1152.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G1S7"
+"UnparsedAddress": "46 Darrell Avenue, Quispamsis, New Brunswick E2G1S7"
+"Coordinates": array:2 [
0 => -65.933875
1 => 45.419588
]
+"Latitude": 45.419588
+"Longitude": -65.933875
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 46 Darrell Avenue; a spacious and well-maintained mini-home offering comfortable, affordable living in a convenient Quispamsis location. Measuring 72 x 16, this home features three bedrooms, including a generously sized primary suite complete with a walk-in closet and full ensuite bath. The home offers an excellent layout with generous room sizes, plenty of storage, and a functional design that provides both comfort and flexibility for everyday living. Hardwood flooring runs throughout the main living areas, and with two full bathrooms, theres plenty of convenience for families or guests alike. The bright main bathroom features a skylight, filling the space with natural light and adding to the homes warm, airy feel. Additional highlights include an air exchanger for year-round comfort and efficiency, a wheelchair-accessible ramp leading into the home, a private deck for outdoor enjoyment which will be fully rebuilt prior to closing, and a storage shed for added practicality. A fantastic opportunity to own a spacious, low-maintenance home close to local amenities and everyday conveniences. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-19T19:19:36.924424+00:00"
+"Directions": "Located in the Quispamsis trailer park."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Pillars & Posts"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007515"
+"ListOfficeKey": "269605"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wheelchair access"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "04974811"
+"PhotosChangeTimestamp": "2026-05-19T17:22:34Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-24T17:13:25Z"
+"TaxAnnualAmount": "1259.9"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29770471/46-darrell-avenue-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1152
+"OriginalEntryTimestamp": "2026-05-19T17:22:34.17Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1289826"
+"ListOfficeNationalAssociationId": "1243995"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 27
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29770471')"
+"ID": "1438357"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 17
+after_key: ""
}
"RF Response Time" => "0.32 seconds"
]
]