2509 Stream Drive Honolulu, HI 96817

Listing
Overview

Price: $999,000
Area: NUUANU AREA
Status: Active

Welcome to this charming 3-bedroom, 2-bathroom home nestled in the desirable Nuuanu neighborhood! With 24 owned PV panels, you'll enjoy energy efficiency and lower utility costs year-round. This home is well kept, presenting a fantastic opportunity to add your personal touch and make it your own. The spacious backyard offers plenty of room for outdoor activities, gardening, or simply relaxing in a serene setting. Located in a great neighborhood, this property provides a great balance of privacy and convenience, along with being in close proximity to schools, parks, churches, Oahu country club, stores, restaurants and much more! Don’t miss the chance to turn this house into your dream home! Listing by: Five Star Realty, Inc. (808) 382-6871

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202423859"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "2509"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Stream"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96817"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "999000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "999000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "NUUANU AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(700) "Welcome to this charming 3-bedroom, 2-bathroom home nestled in the desirable Nuuanu neighborhood! With 24 owned PV panels, you'll enjoy energy efficiency and lower utility costs year-round. This home is well kept, presenting a fantastic opportunity to add your personal touch and make it your own. The spacious backyard offers plenty of room for outdoor activities, gardening, or simply relaxing in a serene setting. Located in a great neighborhood, this property provides a great balance of privacy and convenience, along with being in close proximity to schools, parks, churches, Oahu country club, stores, restaurants and much more! Don’t miss the chance to turn this house into your dream home!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Five Star Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "4994.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "928"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "FIVE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "Vincent@FiveStarRealty.org"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 382-6871"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Vincent Lao"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-21T16:17:42.057"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18322995"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-16T13:55:58.503"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26733993"
  }
  ["listing_image"]=>
  array(24) {
    [0]=>
    string(8) "26733993"
    [1]=>
    string(8) "26733994"
    [2]=>
    string(8) "26733995"
    [3]=>
    string(8) "26733996"
    [4]=>
    string(8) "26733997"
    [5]=>
    string(8) "26733998"
    [6]=>
    string(8) "26733999"
    [7]=>
    string(8) "26734000"
    [8]=>
    string(8) "26734001"
    [9]=>
    string(8) "26734002"
    [10]=>
    string(8) "26734003"
    [11]=>
    string(8) "26734004"
    [12]=>
    string(8) "26734005"
    [13]=>
    string(8) "26734006"
    [14]=>
    string(8) "26734007"
    [15]=>
    string(8) "26734008"
    [16]=>
    string(8) "26734009"
    [17]=>
    string(8) "26734010"
    [18]=>
    string(8) "26734011"
    [19]=>
    string(8) "26734012"
    [20]=>
    string(8) "26734013"
    [21]=>
    string(8) "26734014"
    [22]=>
    string(8) "26734015"
    [23]=>
    string(8) "26734016"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202423859
        )

    [StreetNumber] => Array
        (
            [0] => 2509
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Stream
        )

    [StreetSuffix] => Array
        (
            [0] => Drive
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96817
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 999000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 999000.00
        )

    [Neighbourhood] => Array
        (
            [0] => NUUANU AREA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Welcome to this charming 3-bedroom, 2-bathroom home nestled in the desirable Nuuanu neighborhood! With 24 owned PV panels, you'll enjoy energy efficiency and lower utility costs year-round. This home is well kept, presenting a fantastic opportunity to add your personal touch and make it your own. The spacious backyard offers plenty of room for outdoor activities, gardening, or simply relaxing in a serene setting. Located in a great neighborhood, this property provides a great balance of privacy and convenience, along with being in close proximity to schools, parks, churches, Oahu country club, stores, restaurants and much more! Don’t miss the chance to turn this house into your dream home!
        )

    [ListOfficeName] => Array
        (
            [0] => Five Star Realty, Inc.
        )

    [BedsTotal] => Array
        (
            [0] => 3
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 4994.00
        )

    [SqftTotal] => Array
        (
            [0] => 928
        )

    [YearBuilt] => Array
        (
            [0] => 1975
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Average
        )

    [ParkingTotal] => Array
        (
            [0] => 3
        )

    [StoriesType] => Array
        (
            [0] => One
        )

    [View] => Array
        (
            [0] => None
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => FIVE
        )

    [ListAgentEmail] => Array
        (
            [0] => Vincent@FiveStarRealty.org
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 382-6871
        )

    [ListAgentFullName] => Array
        (
            [0] => Vincent Lao
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-21T16:17:42.057
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18322995
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-10-16T13:55:58.503
        )

    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26733993
        )

    [listing_image] => Array
        (
            [0] => 26733993
            [1] => 26733994
            [2] => 26733995
            [3] => 26733996
            [4] => 26733997
            [5] => 26733998
            [6] => 26733999
            [7] => 26734000
            [8] => 26734001
            [9] => 26734002
            [10] => 26734003
            [11] => 26734004
            [12] => 26734005
            [13] => 26734006
            [14] => 26734007
            [15] => 26734008
            [16] => 26734009
            [17] => 26734010
            [18] => 26734011
            [19] => 26734012
            [20] => 26734013
            [21] => 26734014
            [22] => 26734015
            [23] => 26734016
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 4,994
  • Living (sf): 928
  • Year Built: 1975

  • Property Condition: Average
  • Number of Parking Spaces: 3
  • View: None
  • Listing Office: Five Star Realty, Inc.

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446