Listing
Overview
Price: $1,800,000
Area: QUEENS GATE
Status: Active
LARGE 10,243 SQFT LOT!!! Located in the highly coveted gated community of Queen’s Gate and adjacent to the Hawaii Kai Golf Course with views of Koko Head to the West. This home features high ceilings and a spacious floorplan. Relax or entertain surrounded by a spacious yard with a saltwater pool and hot tub. Lush landscaping with an abundance of fruit trees. Clubhouse/Recreation Center amenities include a custom kitchen, ping pong, foosball, lounge area with large TV, game table, tennis/pickleball and racquetball courts. Experience island living near Sandy Beach, hiking, restaurants, shopping and baccalaureate schools. Add your own personal touches and make this your NEW HOME! Listing by: BHGRE Advantage Realty (808) 282-3203
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424189"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "7899"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Makaaoa"
}
["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/jnxenbz/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1800000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1800000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "QUEENS GATE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(694) "LARGE 10,243 SQFT LOT!!! Located in the highly coveted gated community of Queen’s Gate and adjacent to the Hawaii Kai Golf Course with views of Koko Head to the West. This home features high ceilings and a spacious floorplan. Relax or entertain surrounded by a spacious yard with a saltwater pool and hot tub. Lush landscaping with an abundance of fruit trees. Clubhouse/Recreation Center amenities include a custom kitchen, ping pong, foosball, lounge area with large TV, game table, tennis/pickleball and racquetball courts. Experience island living near Sandy Beach, hiking, restaurants, shopping and baccalaureate schools. Add your own personal touches and make this 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) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10243.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2795"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1980"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(20) "Golf Course,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-29T16:16:54.323"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18332471"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-29T09:55:00.360"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "HawaiiKai"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26749196"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26749196"
[1]=>
string(8) "26749197"
[2]=>
string(8) "26749198"
[3]=>
string(8) "26749199"
[4]=>
string(8) "26749200"
[5]=>
string(8) "26749201"
[6]=>
string(8) "26749202"
[7]=>
string(8) "26749203"
[8]=>
string(8) "26749204"
[9]=>
string(8) "26749205"
[10]=>
string(8) "26749206"
[11]=>
string(8) "26749207"
[12]=>
string(8) "26749208"
[13]=>
string(8) "26749209"
[14]=>
string(8) "26749210"
[15]=>
string(8) "26749211"
[16]=>
string(8) "26749212"
[17]=>
string(8) "26749213"
[18]=>
string(8) "26749214"
[19]=>
string(8) "26749215"
[20]=>
string(8) "26749216"
[21]=>
string(8) "26749217"
[22]=>
string(8) "26749218"
[23]=>
string(8) "26749219"
[24]=>
string(8) "26749220"
[25]=>
string(8) "26749221"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424189
)
[StreetNumber] => Array
(
[0] => 7899
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Makaaoa
)
[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/jnxenbz/unbranded
)
[ListPrice] => Array
(
[0] => 1800000.00
)
[CurrentPrice] => Array
(
[0] => 1800000.00
)
[Neighbourhood] => Array
(
[0] => QUEENS GATE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => LARGE 10,243 SQFT LOT!!! Located in the highly coveted gated community of Queen’s Gate and adjacent to the Hawaii Kai Golf Course with views of Koko Head to the West. This home features high ceilings and a spacious floorplan. Relax or entertain surrounded by a spacious yard with a saltwater pool and hot tub. Lush landscaping with an abundance of fruit trees. Clubhouse/Recreation Center amenities include a custom kitchen, ping pong, foosball, lounge area with large TV, game table, tennis/pickleball and racquetball courts. Experience island living near Sandy Beach, hiking, restaurants, shopping and baccalaureate schools. Add your own personal touches and make this your NEW HOME!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 10243.00
)
[SqftTotal] => Array
(
[0] => 2795
)
[YearBuilt] => Array
(
[0] => 1980
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Golf Course,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[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] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-29T16:16:54.323
)
[Matrix_Unique_ID] => Array
(
[0] => 18332471
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-29T09:55:00.360
)
[MLSAreaMajor] => Array
(
[0] => HawaiiKai
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26749196
)
[listing_image] => Array
(
[0] => 26749196
[1] => 26749197
[2] => 26749198
[3] => 26749199
[4] => 26749200
[5] => 26749201
[6] => 26749202
[7] => 26749203
[8] => 26749204
[9] => 26749205
[10] => 26749206
[11] => 26749207
[12] => 26749208
[13] => 26749209
[14] => 26749210
[15] => 26749211
[16] => 26749212
[17] => 26749213
[18] => 26749214
[19] => 26749215
[20] => 26749216
[21] => 26749217
[22] => 26749218
[23] => 26749219
[24] => 26749220
[25] => 26749221
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 10,243
- Living (sf): 2,795
- Year Built: 1980
- Property Condition: Average
- Number of Parking Spaces: 4
- View: Golf Course,Mountain
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Kamiloiki
- Middle School: Niu Valley
- High School: Kaiser
