Price: $2,050,000 Area: WAIALAE IKI Status: Active
Welcome to your dream single-family home! This stunning newly renovated single-level property features 4 spacious bedrooms and 3 modern bathrooms, perfect for family living or entertaining guests. The open floor plan seamlessly connects the living, dining, and kitchen areas, creating a bright and inviting space that flows effortlessly. Step outside to your own private oasis, where an expansive outdoor patio beckons you to relax and unwind. Dip into the sparkling pool, perfect for those warm days, or host memorable gatherings with friends and family. With contemporary finishes and thoughtful design throughout, this home offers both style and comfort in a tranquil setting. Don't miss the chance to make this beautiful property your own! Listing by: BHGRE Advantage Realty (808) 722-6345
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423558"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "5001"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Poola"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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) "96821"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://listings.hetproductions.com/sites/zeopjxa/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2050000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2050000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "WAIALAE IKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(749) "Welcome to your dream single-family home! This stunning newly renovated single-level property features 4 spacious bedrooms and 3 modern bathrooms, perfect for family living or entertaining guests. The open floor plan seamlessly connects the living, dining, and kitchen areas, creating a bright and inviting space that flows effortlessly. Step outside to your own private oasis, where an expansive outdoor patio beckons you to relax and unwind. Dip into the sparkling pool, perfect for those warm days, or host memorable gatherings with friends and family. With contemporary finishes and thoughtful design throughout, this home offers both style and comfort in a tranquil setting. Don't miss the chance to make this beautiful property your own!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10002.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2865"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1961"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Ocean"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "NeilK@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 722-6345"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Neil TK Kuioka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-14T10:27:49.850"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18313530"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-09T13:07:01.963"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26724445"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26724445"
[1]=>
string(8) "26724446"
[2]=>
string(8) "26724447"
[3]=>
string(8) "26724448"
[4]=>
string(8) "26724449"
[5]=>
string(8) "26724450"
[6]=>
string(8) "26724451"
[7]=>
string(8) "26724452"
[8]=>
string(8) "26724453"
[9]=>
string(8) "26724454"
[10]=>
string(8) "26724455"
[11]=>
string(8) "26724456"
[12]=>
string(8) "26724457"
[13]=>
string(8) "26724458"
[14]=>
string(8) "26724459"
[15]=>
string(8) "26724460"
[16]=>
string(8) "26724461"
[17]=>
string(8) "26724462"
[18]=>
string(8) "26724463"
[19]=>
string(8) "26724464"
[20]=>
string(8) "26724465"
[21]=>
string(8) "26724466"
[22]=>
string(8) "26724467"
[23]=>
string(8) "26724468"
[24]=>
string(8) "26724469"
[25]=>
string(8) "26725551"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423558
)
[StreetNumber] => Array
(
[0] => 5001
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Poola
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/zeopjxa/unbranded
)
[ListPrice] => Array
(
[0] => 2050000.00
)
[CurrentPrice] => Array
(
[0] => 2050000.00
)
[Neighbourhood] => Array
(
[0] => WAIALAE IKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your dream single-family home! This stunning newly renovated single-level property features 4 spacious bedrooms and 3 modern bathrooms, perfect for family living or entertaining guests. The open floor plan seamlessly connects the living, dining, and kitchen areas, creating a bright and inviting space that flows effortlessly. Step outside to your own private oasis, where an expansive outdoor patio beckons you to relax and unwind. Dip into the sparkling pool, perfect for those warm days, or host memorable gatherings with friends and family. With contemporary finishes and thoughtful design throughout, this home offers both style and comfort in a tranquil setting. Don't miss the chance to make this beautiful property your own!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 10002.00
)
[SqftTotal] => Array
(
[0] => 2865
)
[YearBuilt] => Array
(
[0] => 1961
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => NeilK@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 722-6345
)
[ListAgentFullName] => Array
(
[0] => Neil TK Kuioka
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-14T10:27:49.850
)
[Matrix_Unique_ID] => Array
(
[0] => 18313530
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-09T13:07:01.963
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26724445
)
[listing_image] => Array
(
[0] => 26724445
[1] => 26724446
[2] => 26724447
[3] => 26724448
[4] => 26724449
[5] => 26724450
[6] => 26724451
[7] => 26724452
[8] => 26724453
[9] => 26724454
[10] => 26724455
[11] => 26724456
[12] => 26724457
[13] => 26724458
[14] => 26724459
[15] => 26724460
[16] => 26724461
[17] => 26724462
[18] => 26724463
[19] => 26724464
[20] => 26724465
[21] => 26724466
[22] => 26724467
[23] => 26724468
[24] => 26724469
[25] => 26725551
)
)
