Residential Income For Sale

 Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5127
  +post_id: "60627"
  +post_author: 1
  +"ListingKey": "13307bd6f44d169517a876a9a4086ea1"
  +"ListingId": "202601900"
  +"PropertyType": "Residential Income"
  +"PropertySubType": "Duplex"
  +"StandardStatus": "Active"
  +"ModificationTimestamp": "2026-02-02T20:27:29Z"
  +"RFModificationTimestamp": "2026-02-02T20:29:00Z"
  +"ListPrice": 279900.0
  +"BathroomsTotalInteger": 0
  +"BathroomsHalf": 0
  +"BedroomsTotal": 0
  +"LotSizeArea": 4495.392
  +"LivingArea": 0
  +"BuildingAreaTotal": 0
  +"City": "Stellarton"
  +"PostalCode": "B0K 1S0"
  +"UnparsedAddress": "28 Acadia Avenue, Stellarton, NS B0K 1S0"
  +"Coordinates": array:2 [
    0 => -62.661838684
    1 => 45.557241922
  ]
  +"Latitude": 45.557241922
  +"Longitude": -62.661838684
  +"YearBuilt": 0
  +"InternetAddressDisplayYN": true
  +"FeedTypes": "IDX"
  +"ListAgentFullName": "Kelly Stinson"
  +"ListOfficeName": "Blinkhorn Real Estate Ltd."
  +"ListAgentMlsId": "NS21684"
  +"ListOfficeMlsId": "N9609"
  +"OriginatingSystemName": "NSAR"
  +"PublicRemarks": "Prime Stellarton Investment Opportunity!  Welcome to this well-maintained duplex in a highly sought-after location, just steps from Sobeys and the charming amenities of downtown Stellarton. Whether you're expanding your portfolio or becoming a first-time investor, this property offers exceptional value and convenience. Each unit features two bedrooms and one full bath, providing comfortable layouts ideal for tenants. Over the past two years, the home has seen significant updates, including:  Brand new roof, new Avian propane boiler system, renovated main-floor bathroom, insulated basement both units currently vacant, you have the rare opportunity to set your own rents and choose your own tenants from day one. This duplex is not only move-in ready, but also primed to offer strong rental potential in a thriving community.  Don’t miss your chance to invest in one of Stellarton’s most convenient and walkable locations!"
  +"Appliances": array:4 [
    0 => "Stove"
    1 => "Dryer"
    2 => "Washer"
    3 => "Refrigerator"
  ]
  +"Basement": array:2 [
    0 => "Full"
    1 => "Unfinished"
  ]
  +"BelowGradeFinishedAreaUnits": "Square Feet"
  +"BuildingAreaUnits": "Square Feet"
  +"CityRegion": "Northern Region"
  +"CommunityFeatures": array:7 [
    0 => "Park"
    1 => "Playground"
    2 => "Near Public Transport"
    3 => "Recreation Center"
    4 => "School Bus Service"
    5 => "Shopping"
    6 => "Place of Worship"
  ]
  +"ConstructionMaterials": array:1 [
    0 => "Vinyl Siding"
  ]
  +"Country": "CA"
  +"CountyOrParish": "Pictou"
  +"CreationDate": "2026-02-02T17:08:49.522666+00:00"
  +"Directions": "From South Foord Street Stellarton turn left onto Jubilee Avenue, left onto Stellar. Property on corner of Stellar and Acadia. See sign."
  +"ElementarySchool": "G.R. Saunders Elementary School"
  +"FarmLandAreaUnits": "Square Feet"
  +"Flooring": array:3 [
    0 => "Hardwood"
    1 => "Laminate"
    2 => "Vinyl"
  ]
  +"FoundationDetails": array:2 [
    0 => "Concrete Perimeter"
    1 => "Stone"
  ]
  +"GarageYN": true
  +"Heating": array:2 [
    0 => "Hot Water"
    1 => "Radiator"
  ]
  +"HeatingYN": true
  +"HighSchool": "Northumberland Regional High School"
  +"IDXParticipationYN": true
  +"RFTransactionType": "For Sale"
  +"InternetAutomatedValuationDisplayYN": true
  +"InternetConsumerCommentYN": true
  +"InternetEntireListingDisplayYN": true
  +"ListAgentFirstName": "Kelly"
  +"ListAgentKey": "b76176eea6559c074294f661d1603f49"
  +"ListAgentKeyNumeric": "23373"
  +"ListAgentLastName": "Stinson"
  +"ListAgentOfficePhone": "902-759-6070"
  +"ListOfficeEmail": "Fredhaddad1@yahoo.ca"
  +"ListOfficeKey": "7015afd335fa045c4d1ba22b69255836"
  +"ListOfficeKeyNumeric": "670"
  +"ListingContractDate": "2026-02-02"
  +"ListingKeyNumeric": "202601900"
  +"LockBoxLocation": "Side Door"
  +"LotFeatures": array:1 [
    0 => "Under 0.5 Acres"
  ]
  +"LotSizeAcres": 0.1032
  +"LotSizeSquareFeet": 4495.392
  +"MLSAreaMajor": "106-New Glasgow, Stellarton"
  +"MLSAreaMinor": "#15"
  +"MiddleOrJuniorSchool": "Dr. W. A. Macleod Consolidated"
  +"MlsStatus": "ACTIVE"
  +"NumberOfUnitsTotal": "2"
  +"OriginalListPrice": 279900
  +"OriginatingSystemKey": "nsar"
  +"OtherEquipment": array:2 [
    0 => "Sump Pump"
    1 => "Fuel Tank(s)"
  ]
  +"OtherParking": "Garage Details(Detached, Wired)"
  +"Ownership": "Freehold"
  +"ParcelNumber": "00943316"
  +"ParkingFeatures": array:1 [
    0 => "Paved"
  ]
  +"PhotosChangeTimestamp": "2026-02-02T17:03:12Z"
  +"PhotosCount": 15
  +"Possession": array:1 [
    0 => "Immediate At Closing"
  ]
  +"PriceChangeTimestamp": "2026-02-02T00:00:00Z"
  +"Roof": array:1 [
    0 => "Asphalt"
  ]
  +"Sewer": array:1 [
    0 => "Municipal"
  ]
  +"SourceSystemKey": "202601900"
  +"StateOrProvince": "NS"
  +"StreetName": "Acadia"
  +"StreetNumber": "28"
  +"StreetSuffix": "Avenue"
  +"Utilities": array:1 [
    0 => "Propane"
  ]
  +"WaterSource": array:1 [
    0 => "Municipal"
  ]
  +"Zoning": "Residential"
  +"NSAR_LM_Char1_3": "Yes"
  +"NSAR_LM_Char1_14": "Yes"
  +"NSAR_LM_char30_5": "3000 year"
  +"NSAR_LM_char30_7": "1000"
  +"NSAR_LM_char30_9": "4800"
  +"NSAR_LA1_Char10_1": "NS21684"
  +"NSAR_LA1_Char10_2": "N9609"
  +"NSAR_LA1_Char10_4": "1413631"
  +"NSAR_LA1_Char50_1": "NS21684"
  +"NSAR_LM_Char10_20": "Yes"
  +"NSAR_LM_Char10_21": "No"
  +"NSAR_LM_Char10_23": "Yes"
  +"NSAR_LM_Char25_21": "1413631"
  +"NSAR_LM_Char25_23": "1142402"
  +"NSAR_LM_char10_49": "Exempt from HST"
  +"NSAR_LM_char30_13": "2200"
  +"NSAR_LO1_Char10_4": "1142402"
  +"NSAR_LMD_MP_Quality": 1
  +"NSAR_LO1_Char1024_1": "Zillow, Inc."
  +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('13307bd6f44d169517a876a9a4086ea1')"
  +"provider_name": "NSAR"
  +"Media": array:15 [
    0 => array:13 [
      "Order" => 1
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m1"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/853b0667d08f18c2f4f4094fb65d6ec4.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 1133355
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-853b0667d08f18c2f4f4094fb65d6ec4.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_1"
      "ShortDescription" => "View of front of house"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    1 => array:13 [
      "Order" => 2
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m2"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/2e2cb63d340ffcf75e8bb7c0de919a3e.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 96154
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-2e2cb63d340ffcf75e8bb7c0de919a3e.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_2"
      "ShortDescription" => "Kitchen with light wood finished floors, light countertops, and dark wood finish cabinets"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    2 => array:13 [
      "Order" => 3
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m3"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/2a708dafac8f20bddcb0aeb165011bb4.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 96386
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-2a708dafac8f20bddcb0aeb165011bb4.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_3"
      "ShortDescription" => "Kitchen with dark wood finish cabinets, light countertops, light wood-style floors, tasteful backsplash, and wainscoting"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    3 => array:13 [
      "Order" => 4
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m4"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/d524aa7028ba33310866ae892b73e79f.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 104715
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-d524aa7028ba33310866ae892b73e79f.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_4"
      "ShortDescription" => "Kitchen with stainless steel appliances, dark wood finish cabinets, radiator heating unit, light countertops, and light wood-type flooring"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    4 => array:13 [
      "Order" => 5
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m5"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/bd2422d5df91fe1c5f4c8fe1815ba12a.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 55320
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-bd2422d5df91fe1c5f4c8fe1815ba12a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_5"
      "ShortDescription" => "Half bath featuring vanity, a baseboard heating unit, and recessed lighting"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    5 => array:13 [
      "Order" => 6
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m6"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/af9522a38dc52d5d89349edcf7228735.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 107646
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-af9522a38dc52d5d89349edcf7228735.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_6"
      "ShortDescription" => "Laundry room featuring independent washer and dryer"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    6 => array:13 [
      "Order" => 7
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m7"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/c5d348b9e1e745bc5a119a5c582e76fd.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 107640
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-c5d348b9e1e745bc5a119a5c582e76fd.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_7"
      "ShortDescription" => "Living room with wood-type flooring and baseboards"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    7 => array:13 [
      "Order" => 8
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m8"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/4839f69b091be47b02a631f9571f29d4.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 112880
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-4839f69b091be47b02a631f9571f29d4.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_8"
      "ShortDescription" => "Living room featuring wood finished floors, radiator heating unit, and recessed lighting"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    8 => array:13 [
      "Order" => 9
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m9"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/e15aa5ebe358142f3dafdec76db6cf4a.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 83299
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-e15aa5ebe358142f3dafdec76db6cf4a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_9"
      "ShortDescription" => "Entryway featuring radiator heating unit"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    9 => array:13 [
      "Order" => 10
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m10"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/7cadc9166c4fbc533f88f085fc1812db.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 90554
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-7cadc9166c4fbc533f88f085fc1812db.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_10"
      "ShortDescription" => "Dining area featuring radiator and light wood-type flooring"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    10 => array:13 [
      "Order" => 11
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m11"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/8316c0343c2db5ce68be6bfe4f03ecfc.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 100863
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-8316c0343c2db5ce68be6bfe4f03ecfc.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_11"
      "ShortDescription" => "Bedroom featuring radiator and wood finished floors"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    11 => array:13 [
      "Order" => 12
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m12"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/1dbe55f3a4a67225c07175cf2f53f367.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 108997
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-1dbe55f3a4a67225c07175cf2f53f367.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_12"
      "ShortDescription" => "Bedroom with dark wood-style flooring, wallpapered walls, and radiator heating unit"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    12 => array:13 [
      "Order" => 13
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m13"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/ed3c3e1a537dd030dccac7e20dde0061.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 52546
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-ed3c3e1a537dd030dccac7e20dde0061.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_13"
      "ShortDescription" => "Empty room featuring radiator heating unit and dark wood-style flooring"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    13 => array:13 [
      "Order" => 14
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m14"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/b8678cb13473e5f11556d9d13ba54574.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 1163935
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-b8678cb13473e5f11556d9d13ba54574.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_14"
      "ShortDescription" => "Yard layered in snow with an outdoor structure, a garage, and a deck"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
    14 => array:13 [
      "Order" => 15
      "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m15"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/736359f638497dad8673a62d80911d5d.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 793829
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-736359f638497dad8673a62d80911d5d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202601900_15"
      "ShortDescription" => "View of front of home with a chimney"
      "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
    ]
  ]
  +"ID": "60627"
}

 array:2 [
  "RF Query: /Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active', 'Active Under Contract')) and ListingKey eq '13307bd6f44d169517a876a9a4086ea1'/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active', 'Active Under Contract')) and ListingKey eq '13307bd6f44d169517a876a9a4086ea1'&$expand=Media/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active', 'Active Under Contract')) and ListingKey eq '13307bd6f44d169517a876a9a4086ea1'/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active', 'Active Under Contract')) and ListingKey eq '13307bd6f44d169517a876a9a4086ea1'&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5129
      +items: array:1 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5127
          +post_id: "60627"
          +post_author: 1
          +"ListingKey": "13307bd6f44d169517a876a9a4086ea1"
          +"ListingId": "202601900"
          +"PropertyType": "Residential Income"
          +"PropertySubType": "Duplex"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-02-02T20:27:29Z"
          +"RFModificationTimestamp": "2026-02-02T20:29:00Z"
          +"ListPrice": 279900.0
          +"BathroomsTotalInteger": 0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 0
          +"LotSizeArea": 4495.392
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Stellarton"
          +"PostalCode": "B0K 1S0"
          +"UnparsedAddress": "28 Acadia Avenue, Stellarton, NS B0K 1S0"
          +"Coordinates": array:2 [
            0 => -62.661838684
            1 => 45.557241922
          ]
          +"Latitude": 45.557241922
          +"Longitude": -62.661838684
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"ListAgentFullName": "Kelly Stinson"
          +"ListOfficeName": "Blinkhorn Real Estate Ltd."
          +"ListAgentMlsId": "NS21684"
          +"ListOfficeMlsId": "N9609"
          +"OriginatingSystemName": "NSAR"
          +"PublicRemarks": "Prime Stellarton Investment Opportunity!  Welcome to this well-maintained duplex in a highly sought-after location, just steps from Sobeys and the charming amenities of downtown Stellarton. Whether you're expanding your portfolio or becoming a first-time investor, this property offers exceptional value and convenience. Each unit features two bedrooms and one full bath, providing comfortable layouts ideal for tenants. Over the past two years, the home has seen significant updates, including:  Brand new roof, new Avian propane boiler system, renovated main-floor bathroom, insulated basement both units currently vacant, you have the rare opportunity to set your own rents and choose your own tenants from day one. This duplex is not only move-in ready, but also primed to offer strong rental potential in a thriving community.  Don’t miss your chance to invest in one of Stellarton’s most convenient and walkable locations!"
          +"Appliances": array:4 [
            0 => "Stove"
            1 => "Dryer"
            2 => "Washer"
            3 => "Refrigerator"
          ]
          +"Basement": array:2 [
            0 => "Full"
            1 => "Unfinished"
          ]
          +"BelowGradeFinishedAreaUnits": "Square Feet"
          +"BuildingAreaUnits": "Square Feet"
          +"CityRegion": "Northern Region"
          +"CommunityFeatures": array:7 [
            0 => "Park"
            1 => "Playground"
            2 => "Near Public Transport"
            3 => "Recreation Center"
            4 => "School Bus Service"
            5 => "Shopping"
            6 => "Place of Worship"
          ]
          +"ConstructionMaterials": array:1 [
            0 => "Vinyl Siding"
          ]
          +"Country": "CA"
          +"CountyOrParish": "Pictou"
          +"CreationDate": "2026-02-02T17:08:49.522666+00:00"
          +"Directions": "From South Foord Street Stellarton turn left onto Jubilee Avenue, left onto Stellar. Property on corner of Stellar and Acadia. See sign."
          +"ElementarySchool": "G.R. Saunders Elementary School"
          +"FarmLandAreaUnits": "Square Feet"
          +"Flooring": array:3 [
            0 => "Hardwood"
            1 => "Laminate"
            2 => "Vinyl"
          ]
          +"FoundationDetails": array:2 [
            0 => "Concrete Perimeter"
            1 => "Stone"
          ]
          +"GarageYN": true
          +"Heating": array:2 [
            0 => "Hot Water"
            1 => "Radiator"
          ]
          +"HeatingYN": true
          +"HighSchool": "Northumberland Regional High School"
          +"IDXParticipationYN": true
          +"RFTransactionType": "For Sale"
          +"InternetAutomatedValuationDisplayYN": true
          +"InternetConsumerCommentYN": true
          +"InternetEntireListingDisplayYN": true
          +"ListAgentFirstName": "Kelly"
          +"ListAgentKey": "b76176eea6559c074294f661d1603f49"
          +"ListAgentKeyNumeric": "23373"
          +"ListAgentLastName": "Stinson"
          +"ListAgentOfficePhone": "902-759-6070"
          +"ListOfficeEmail": "Fredhaddad1@yahoo.ca"
          +"ListOfficeKey": "7015afd335fa045c4d1ba22b69255836"
          +"ListOfficeKeyNumeric": "670"
          +"ListingContractDate": "2026-02-02"
          +"ListingKeyNumeric": "202601900"
          +"LockBoxLocation": "Side Door"
          +"LotFeatures": array:1 [
            0 => "Under 0.5 Acres"
          ]
          +"LotSizeAcres": 0.1032
          +"LotSizeSquareFeet": 4495.392
          +"MLSAreaMajor": "106-New Glasgow, Stellarton"
          +"MLSAreaMinor": "#15"
          +"MiddleOrJuniorSchool": "Dr. W. A. Macleod Consolidated"
          +"MlsStatus": "ACTIVE"
          +"NumberOfUnitsTotal": "2"
          +"OriginalListPrice": 279900
          +"OriginatingSystemKey": "nsar"
          +"OtherEquipment": array:2 [
            0 => "Sump Pump"
            1 => "Fuel Tank(s)"
          ]
          +"OtherParking": "Garage Details(Detached, Wired)"
          +"Ownership": "Freehold"
          +"ParcelNumber": "00943316"
          +"ParkingFeatures": array:1 [
            0 => "Paved"
          ]
          +"PhotosChangeTimestamp": "2026-02-02T17:03:12Z"
          +"PhotosCount": 15
          +"Possession": array:1 [
            0 => "Immediate At Closing"
          ]
          +"PriceChangeTimestamp": "2026-02-02T00:00:00Z"
          +"Roof": array:1 [
            0 => "Asphalt"
          ]
          +"Sewer": array:1 [
            0 => "Municipal"
          ]
          +"SourceSystemKey": "202601900"
          +"StateOrProvince": "NS"
          +"StreetName": "Acadia"
          +"StreetNumber": "28"
          +"StreetSuffix": "Avenue"
          +"Utilities": array:1 [
            0 => "Propane"
          ]
          +"WaterSource": array:1 [
            0 => "Municipal"
          ]
          +"Zoning": "Residential"
          +"NSAR_LM_Char1_3": "Yes"
          +"NSAR_LM_Char1_14": "Yes"
          +"NSAR_LM_char30_5": "3000 year"
          +"NSAR_LM_char30_7": "1000"
          +"NSAR_LM_char30_9": "4800"
          +"NSAR_LA1_Char10_1": "NS21684"
          +"NSAR_LA1_Char10_2": "N9609"
          +"NSAR_LA1_Char10_4": "1413631"
          +"NSAR_LA1_Char50_1": "NS21684"
          +"NSAR_LM_Char10_20": "Yes"
          +"NSAR_LM_Char10_21": "No"
          +"NSAR_LM_Char10_23": "Yes"
          +"NSAR_LM_Char25_21": "1413631"
          +"NSAR_LM_Char25_23": "1142402"
          +"NSAR_LM_char10_49": "Exempt from HST"
          +"NSAR_LM_char30_13": "2200"
          +"NSAR_LO1_Char10_4": "1142402"
          +"NSAR_LMD_MP_Quality": 1
          +"NSAR_LO1_Char1024_1": "Zillow, Inc."
          +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('13307bd6f44d169517a876a9a4086ea1')"
          +"provider_name": "NSAR"
          +"Media": array:15 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/853b0667d08f18c2f4f4094fb65d6ec4.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 1133355
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-853b0667d08f18c2f4f4094fb65d6ec4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_1"
              "ShortDescription" => "View of front of house"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/2e2cb63d340ffcf75e8bb7c0de919a3e.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 96154
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-2e2cb63d340ffcf75e8bb7c0de919a3e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_2"
              "ShortDescription" => "Kitchen with light wood finished floors, light countertops, and dark wood finish cabinets"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            2 => array:13 [
              "Order" => 3
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/2a708dafac8f20bddcb0aeb165011bb4.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 96386
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-2a708dafac8f20bddcb0aeb165011bb4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_3"
              "ShortDescription" => "Kitchen with dark wood finish cabinets, light countertops, light wood-style floors, tasteful backsplash, and wainscoting"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            3 => array:13 [
              "Order" => 4
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/d524aa7028ba33310866ae892b73e79f.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 104715
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-d524aa7028ba33310866ae892b73e79f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_4"
              "ShortDescription" => "Kitchen with stainless steel appliances, dark wood finish cabinets, radiator heating unit, light countertops, and light wood-type flooring"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            4 => array:13 [
              "Order" => 5
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/bd2422d5df91fe1c5f4c8fe1815ba12a.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 55320
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-bd2422d5df91fe1c5f4c8fe1815ba12a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_5"
              "ShortDescription" => "Half bath featuring vanity, a baseboard heating unit, and recessed lighting"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            5 => array:13 [
              "Order" => 6
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/af9522a38dc52d5d89349edcf7228735.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 107646
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-af9522a38dc52d5d89349edcf7228735.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_6"
              "ShortDescription" => "Laundry room featuring independent washer and dryer"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            6 => array:13 [
              "Order" => 7
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/c5d348b9e1e745bc5a119a5c582e76fd.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 107640
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-c5d348b9e1e745bc5a119a5c582e76fd.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_7"
              "ShortDescription" => "Living room with wood-type flooring and baseboards"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            7 => array:13 [
              "Order" => 8
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m8"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/4839f69b091be47b02a631f9571f29d4.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 112880
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-4839f69b091be47b02a631f9571f29d4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_8"
              "ShortDescription" => "Living room featuring wood finished floors, radiator heating unit, and recessed lighting"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            8 => array:13 [
              "Order" => 9
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m9"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/e15aa5ebe358142f3dafdec76db6cf4a.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 83299
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-e15aa5ebe358142f3dafdec76db6cf4a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_9"
              "ShortDescription" => "Entryway featuring radiator heating unit"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            9 => array:13 [
              "Order" => 10
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m10"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/7cadc9166c4fbc533f88f085fc1812db.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 90554
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-7cadc9166c4fbc533f88f085fc1812db.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_10"
              "ShortDescription" => "Dining area featuring radiator and light wood-type flooring"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            10 => array:13 [
              "Order" => 11
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m11"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/8316c0343c2db5ce68be6bfe4f03ecfc.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 100863
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-8316c0343c2db5ce68be6bfe4f03ecfc.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_11"
              "ShortDescription" => "Bedroom featuring radiator and wood finished floors"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            11 => array:13 [
              "Order" => 12
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m12"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/1dbe55f3a4a67225c07175cf2f53f367.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 108997
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-1dbe55f3a4a67225c07175cf2f53f367.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_12"
              "ShortDescription" => "Bedroom with dark wood-style flooring, wallpapered walls, and radiator heating unit"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            12 => array:13 [
              "Order" => 13
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m13"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/ed3c3e1a537dd030dccac7e20dde0061.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 52546
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-ed3c3e1a537dd030dccac7e20dde0061.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_13"
              "ShortDescription" => "Empty room featuring radiator heating unit and dark wood-style flooring"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            13 => array:13 [
              "Order" => 14
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m14"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/b8678cb13473e5f11556d9d13ba54574.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 1163935
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-b8678cb13473e5f11556d9d13ba54574.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_14"
              "ShortDescription" => "Yard layered in snow with an outdoor structure, a garage, and a deck"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
            14 => array:13 [
              "Order" => 15
              "MediaKey" => "13307bd6f44d169517a876a9a4086ea1-m15"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/736359f638497dad8673a62d80911d5d.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 793829
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/13307bd6f44d169517a876a9a4086ea1/thumbnail-736359f638497dad8673a62d80911d5d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202601900_15"
              "ShortDescription" => "View of front of home with a chimney"
              "ResourceRecordKey" => "13307bd6f44d169517a876a9a4086ea1"
            ]
          ]
          +"ID": "60627"
        }
      ]
      +success: true
      +page_size: 1
      +page_count: 1
      +count: 1
      +after_key: ""
    }
    "RF Response Time" => "0.05 seconds"
  ]
  "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '13307bd6f44d169517a876a9a4086ea1'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#7466
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.04 seconds"
  ]
]