629 Ulili Street Honolulu, HI 96816

Listing
Overview

Price: $3,199,800
Area: KAHALA AREA
Status: Active

Welcome to your dream home! This stunning two-story residence boasts elegance and luxury in every detail. Nestled in the prestigious neighborhood of Kahala, the property features a spacious and beautifully landscaped yard, perfect for outdoor entertaining an leisure. The highlight of this magnificent home is the sparkling in-ground pool, surrounded by lush green lawn and tropical landscaping that provides serene and private oasis. This home is conveniently located to Kahala Beach, shopping mall, dining, grocery stores and entertainment options. Don't miss the opportunity to own this exceptional property that combines luxury, comfort and convenience. Listing by: Five Star Realty, Inc. (808) 741-5789

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202414392"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "629"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Ulili"
  }
  ["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) "96816"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "3199800.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "3199800.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "KAHALA AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(657) "Welcome to your dream home! This stunning two-story residence boasts elegance and luxury in every detail. Nestled in the prestigious neighborhood of Kahala, the property features a spacious and beautifully landscaped yard, perfect for outdoor entertaining an leisure. The highlight of this magnificent home is the sparkling in-ground pool, surrounded by lush green lawn and tropical landscaping that provides serene and private oasis. This home is conveniently located to Kahala Beach, shopping mall, dining, grocery stores and entertainment options. Don't miss the opportunity to own this exceptional property that combines luxury, comfort and convenience."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Five Star Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "11239.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "4476"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1988"
  }
  ["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(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahala"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kalani"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(6) "FIVE02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "thompson@fivestarrealty.org"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 741-5789"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Thompson H Pham"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-17T09:39:10.900"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18075591"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-17T09:39:10.900"
  }
  ["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) "26587906"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26587906"
    [1]=>
    string(8) "26587907"
    [2]=>
    string(8) "26587908"
    [3]=>
    string(8) "26587909"
    [4]=>
    string(8) "26587910"
    [5]=>
    string(8) "26587911"
    [6]=>
    string(8) "26587912"
    [7]=>
    string(8) "26587913"
    [8]=>
    string(8) "26587914"
    [9]=>
    string(8) "26587915"
    [10]=>
    string(8) "26587916"
    [11]=>
    string(8) "26587917"
    [12]=>
    string(8) "26587918"
    [13]=>
    string(8) "26587919"
    [14]=>
    string(8) "26587920"
    [15]=>
    string(8) "26587921"
    [16]=>
    string(8) "26587922"
    [17]=>
    string(8) "26587923"
    [18]=>
    string(8) "26587924"
    [19]=>
    string(8) "26587925"
    [20]=>
    string(8) "26587926"
    [21]=>
    string(8) "26587927"
    [22]=>
    string(8) "26587928"
    [23]=>
    string(8) "26587929"
    [24]=>
    string(8) "26587930"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202414392
        )

    [StreetNumber] => Array
        (
            [0] => 629
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Ulili
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96816
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 3199800.00
        )

    [CurrentPrice] => Array
        (
            [0] => 3199800.00
        )

    [Neighbourhood] => Array
        (
            [0] => KAHALA AREA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Welcome to your dream home! This stunning two-story residence boasts elegance and luxury in every detail. Nestled in the prestigious neighborhood of Kahala, the property features a spacious and beautifully landscaped yard, perfect for outdoor entertaining an leisure. The highlight of this magnificent home is the sparkling in-ground pool, surrounded by lush green lawn and tropical landscaping that provides serene and private oasis. This home is conveniently located to Kahala Beach, shopping mall, dining, grocery stores and entertainment options. Don't miss the opportunity to own this exceptional property that combines luxury, comfort and convenience.
        )

    [ListOfficeName] => Array
        (
            [0] => Five Star Realty, Inc.
        )

    [BedsTotal] => Array
        (
            [0] => 5
        )

    [BathsFull] => Array
        (
            [0] => 5
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 11239.00
        )

    [SqftTotal] => Array
        (
            [0] => 4476
        )

    [YearBuilt] => Array
        (
            [0] => 1988
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Average
        )

    [ParkingTotal] => Array
        (
            [0] => 4
        )

    [StoriesType] => Array
        (
            [0] => Two
        )

    [View] => Array
        (
            [0] => None
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => Kahala
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => Kaimuki
        )

    [HighSchool] => Array
        (
            [0] => Kalani
        )

    [ListOfficeMLSID] => Array
        (
            [0] => FIVE02
        )

    [ListAgentEmail] => Array
        (
            [0] => thompson@fivestarrealty.org
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 741-5789
        )

    [ListAgentFullName] => Array
        (
            [0] => Thompson H Pham
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-06-17T09:39:10.900
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18075591
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-06-17T09:39:10.900
        )

    [MLSAreaMajor] => Array
        (
            [0] => DiamondHd
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26587906
        )

    [listing_image] => Array
        (
            [0] => 26587906
            [1] => 26587907
            [2] => 26587908
            [3] => 26587909
            [4] => 26587910
            [5] => 26587911
            [6] => 26587912
            [7] => 26587913
            [8] => 26587914
            [9] => 26587915
            [10] => 26587916
            [11] => 26587917
            [12] => 26587918
            [13] => 26587919
            [14] => 26587920
            [15] => 26587921
            [16] => 26587922
            [17] => 26587923
            [18] => 26587924
            [19] => 26587925
            [20] => 26587926
            [21] => 26587927
            [22] => 26587928
            [23] => 26587929
            [24] => 26587930
        )

)

  • BedsTotal: 5
  • Full Baths: 5
  • Land Area (sf): 11,239
  • Living (sf): 4,476
  • Year Built: 1988

  • Property Condition: Average
  • Number of Parking Spaces: 4
  • View: None
  • Listing Office: Five Star Realty, Inc.

  • Land Tenure: FS - Fee Simple

  • Elementary School: Kahala
  • Middle School: Kaimuki
  • High School: Kalani

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446