Listing
Overview
Price: $1,588,000
Area: QUEENS GATE
Status: Active Under Contract
Located in the highly coveted gated community of Queen’s Gate and adjacent to the Hawaii Kai Golf Course with views of Koko Head and the Koolau mountains. Single level, spacious executive style home with a swimming pool. Freshly painted interior and exterior walls. Large garage with an extra refrigerator. Clubhouse/Recreation Center amenities include a custom kitchen, ping pong, foosball, lounge area with large TV, game table, tennis/pickleball, racquetball and WiFi. Experience island living near Sandy Beach, hiking, restaurants, shopping and baccalaureate schools. Add your own personal touches. This is your NEW Home! Listing by: BHGRE Advantage Realty (808) 282-3203
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501478"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "7704"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kalohelani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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) "96825"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://listings.hetproductions.com/sites/lkemoxo/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1588000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "QUEENS GATE"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(634) "Located in the highly coveted gated community of Queen’s Gate and adjacent to the Hawaii Kai Golf Course with views of Koko Head and the Koolau mountains. Single level, spacious executive style home with a swimming pool. Freshly painted interior and exterior walls. Large garage with an extra refrigerator. Clubhouse/Recreation Center amenities include a custom kitchen, ping pong, foosball, lounge area with large TV, game table, tennis/pickleball, racquetball and WiFi. Experience island living near Sandy Beach, hiking, restaurants, shopping and baccalaureate schools. Add your own personal touches. This is your NEW Home!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["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) "6250.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1972"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1979"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(20) "Golf Course,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "262.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Kamiloiki"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kaiser"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "ReneeO@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 282-3203"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Renee R Oyama Evans"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18478714"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-07T08:25:26.363"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-14"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "HawaiiKai"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:25:26.363"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26838930"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26838930"
[1]=>
string(8) "26838931"
[2]=>
string(8) "26838932"
[3]=>
string(8) "26838933"
[4]=>
string(8) "26838934"
[5]=>
string(8) "26838935"
[6]=>
string(8) "26838936"
[7]=>
string(8) "26838937"
[8]=>
string(8) "26838938"
[9]=>
string(8) "26838939"
[10]=>
string(8) "26838940"
[11]=>
string(8) "26838941"
[12]=>
string(8) "26838942"
[13]=>
string(8) "26838943"
[14]=>
string(8) "26838944"
[15]=>
string(8) "26838945"
[16]=>
string(8) "26838946"
[17]=>
string(8) "26838947"
[18]=>
string(8) "26838948"
[19]=>
string(8) "26838949"
[20]=>
string(8) "26838950"
[21]=>
string(8) "26838951"
[22]=>
string(8) "26838952"
[23]=>
string(8) "26838953"
[24]=>
string(8) "26838954"
[25]=>
string(8) "26838955"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501478
)
[StreetNumber] => Array
(
[0] => 7704
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kalohelani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96825
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/lkemoxo/unbranded
)
[ListPrice] => Array
(
[0] => 1588000.00
)
[Neighbourhood] => Array
(
[0] => QUEENS GATE
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Located in the highly coveted gated community of Queen’s Gate and adjacent to the Hawaii Kai Golf Course with views of Koko Head and the Koolau mountains. Single level, spacious executive style home with a swimming pool. Freshly painted interior and exterior walls. Large garage with an extra refrigerator. Clubhouse/Recreation Center amenities include a custom kitchen, ping pong, foosball, lounge area with large TV, game table, tennis/pickleball, racquetball and WiFi. Experience island living near Sandy Beach, hiking, restaurants, shopping and baccalaureate schools. Add your own personal touches. This is your NEW Home!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6250.00
)
[SqftTotal] => Array
(
[0] => 1972
)
[YearBuilt] => Array
(
[0] => 1979
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Golf Course,Mountain
)
[MaintenanceExpense] => Array
(
[0] => 262.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kamiloiki
)
[MiddleOrJuniorSchool] => Array
(
[0] => Niu Valley
)
[HighSchool] => Array
(
[0] => Kaiser
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => ReneeO@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 282-3203
)
[ListAgentFullName] => Array
(
[0] => Renee R Oyama Evans
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18478714
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-07T08:25:26.363
)
[ListingContractDate] => Array
(
[0] => 2025-01-14
)
[MLSAreaMajor] => Array
(
[0] => HawaiiKai
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:25:26.363
)
[_thumbnail_id] => Array
(
[0] => 26838930
)
[listing_image] => Array
(
[0] => 26838930
[1] => 26838931
[2] => 26838932
[3] => 26838933
[4] => 26838934
[5] => 26838935
[6] => 26838936
[7] => 26838937
[8] => 26838938
[9] => 26838939
[10] => 26838940
[11] => 26838941
[12] => 26838942
[13] => 26838943
[14] => 26838944
[15] => 26838945
[16] => 26838946
[17] => 26838947
[18] => 26838948
[19] => 26838949
[20] => 26838950
[21] => 26838951
[22] => 26838952
[23] => 26838953
[24] => 26838954
[25] => 26838955
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 6,250 sf
- Living (sf): 1,972
- Year Built: 1979
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Golf Course,Mountain
- Listing Office: BHGRE Advantage Realty
- Maintenance Fees: $262
- Land Tenure: FS - Fee Simple
- Elementary School: Kamiloiki
- Middle School: Niu Valley
- High School: Kaiser
