Listing
Overview
Price: $1,850,000
Area: QUEENS GATE
Status: Active
Rarely available 5 bedroom in the private gated community of Queens Gate 2! SEE THE VIDEO! This single story, corner lot property boasts 5 bedrooms, 2 baths, plus separate office with full bath, tiled pool, vaulted living room ceiling and 6 split AC systems. Primary bedroom has a private ensuite bath, second bedroom has a private entry to its secluded landscaped yard. The community amenities include pickleball, tennis and racquetball courts and recreation room for private gatherings. Feel the exclusivity of this gated community surrounded by Hawaii Kai Golf Course and close proximity to the beach! Don't miss it! OPEN HOUSE SUNDAY, 11/12/23 2:00-5:00pm Listing by: Coldwell Banker Realty
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202316328"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "7875"
}
["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(81) "https://protect-usb.mimecast.com/s/RDx6CR8vrAIKoPpQH9IOwQ?domain=player.vimeo.com"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1850000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1850000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "QUEENS GATE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(659) "Rarely available 5 bedroom in the private gated community of Queens Gate 2! SEE THE VIDEO! This single story, corner lot property boasts 5 bedrooms, 2 baths, plus separate office with full bath, tiled pool, vaulted living room ceiling and 6 split AC systems. Primary bedroom has a private ensuite bath, second bedroom has a private entry to its secluded landscaped yard. The community amenities include pickleball, tennis and racquetball courts and recreation room for private gatherings. Feel the exclusivity of this gated community surrounded by Hawaii Kai Golf Course and close proximity to the beach! Don't miss it! OPEN HOUSE SUNDAY, 11/12/23 2:00-5:00pm"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6934.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2478"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1979"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["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(6) "CBPP04"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "calen.kw@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Calen M Kim-Walker"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-11-12T17:00:01.433"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17437431"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-07-12T10:07:16.170"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25873635"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25873635"
[1]=>
string(8) "25873636"
[2]=>
string(8) "25873637"
[3]=>
string(8) "25873638"
[4]=>
string(8) "25873639"
[5]=>
string(8) "25873640"
[6]=>
string(8) "25873641"
[7]=>
string(8) "25873642"
[8]=>
string(8) "25873643"
[9]=>
string(8) "25873644"
[10]=>
string(8) "25873645"
[11]=>
string(8) "25873646"
[12]=>
string(8) "25873647"
[13]=>
string(8) "25873648"
[14]=>
string(8) "25873649"
[15]=>
string(8) "25873650"
[16]=>
string(8) "25873651"
[17]=>
string(8) "25873652"
[18]=>
string(8) "25873653"
[19]=>
string(8) "25873654"
[20]=>
string(8) "25873655"
[21]=>
string(8) "25873656"
[22]=>
string(8) "25873657"
[23]=>
string(8) "25873658"
[24]=>
string(8) "25873659"
[25]=>
string(8) "25873660"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "HawaiiKai"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202316328
)
[StreetNumber] => Array
(
[0] => 7875
)
[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://protect-usb.mimecast.com/s/RDx6CR8vrAIKoPpQH9IOwQ?domain=player.vimeo.com
)
[ListPrice] => Array
(
[0] => 1850000.00
)
[CurrentPrice] => Array
(
[0] => 1850000.00
)
[Neighbourhood] => Array
(
[0] => QUEENS GATE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Rarely available 5 bedroom in the private gated community of Queens Gate 2! SEE THE VIDEO! This single story, corner lot property boasts 5 bedrooms, 2 baths, plus separate office with full bath, tiled pool, vaulted living room ceiling and 6 split AC systems. Primary bedroom has a private ensuite bath, second bedroom has a private entry to its secluded landscaped yard. The community amenities include pickleball, tennis and racquetball courts and recreation room for private gatherings. Feel the exclusivity of this gated community surrounded by Hawaii Kai Golf Course and close proximity to the beach! Don't miss it! OPEN HOUSE SUNDAY, 11/12/23 2:00-5:00pm
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6934.00
)
[SqftTotal] => Array
(
[0] => 2478
)
[YearBuilt] => Array
(
[0] => 1979
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Golf Course
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP04
)
[ListAgentEmail] => Array
(
[0] => calen.kw@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Calen M Kim-Walker
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-11-12T17:00:01.433
)
[Matrix_Unique_ID] => Array
(
[0] => 17437431
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-07-12T10:07:16.170
)
[_thumbnail_id] => Array
(
[0] => 25873635
)
[listing_image] => Array
(
[0] => 25873635
[1] => 25873636
[2] => 25873637
[3] => 25873638
[4] => 25873639
[5] => 25873640
[6] => 25873641
[7] => 25873642
[8] => 25873643
[9] => 25873644
[10] => 25873645
[11] => 25873646
[12] => 25873647
[13] => 25873648
[14] => 25873649
[15] => 25873650
[16] => 25873651
[17] => 25873652
[18] => 25873653
[19] => 25873654
[20] => 25873655
[21] => 25873656
[22] => 25873657
[23] => 25873658
[24] => 25873659
[25] => 25873660
)
[MLSAreaMajor] => Array
(
[0] => HawaiiKai
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 5
- Full Baths: 3
- Land Area (sf): 6,934
- Living (sf): 2,478
- Year Built: 1979
- Property Condition: Above Average,Average
- Number of Parking Spaces: 1
- View: Golf Course
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple