Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
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
)
)