1848 Ala Noe Place Honolulu, HI 96819

Listing
Overview

Price: $1,299,000
Area: MOANALUA VALLEY
Status: Active Under Contract

Welcome to your dream home nestled in the highly desired Moanalua Valley. This charming 4 bedroom, 2.5 bath residence boasts breathtaking mountain views and a large beautiful landscaped yard that is envied by neighbors. This gorgeous home is move-in ready with a newly renovated kitchen featuring quartz counter tops, shaker cabinets, and newly installed luxury vinyl flooring that completes the look of this exceptional home. BONUS FEATURE - a downstairs basement room complete with its own entrance and full bath, perfect for a guest room. Situated in a prime location with easy access to the freeway and conveniently located near distinguished schools, hospitals, churches, golf course and parks. You'll be minutes away from the airport, military bases and shopping malls. Don't miss this opportunity to make this home your own! Schedule a showing today! Listing by: Trinity Properties, LLC (808) 479-2089

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202407509"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1848"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Ala Noe"
  }
  ["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) "96819"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1299000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1299000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(15) "MOANALUA VALLEY"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(864) "Welcome to your dream home nestled in the highly desired Moanalua Valley.  This charming 4 bedroom, 2.5 bath residence boasts breathtaking mountain views and a large beautiful landscaped yard that is envied by neighbors.  This gorgeous home is move-in ready with a newly renovated kitchen featuring quartz counter tops, shaker cabinets, and newly installed luxury vinyl flooring that completes the look of this exceptional home.  BONUS FEATURE - a downstairs basement room complete with its own entrance and full bath, perfect for a guest room.  Situated in a prime location with easy access to the freeway and conveniently located near distinguished schools, hospitals, churches, golf course and parks.  You'll be minutes away from the airport, military bases  and shopping malls. Don't miss this opportunity to make this home your own!  Schedule a showing today!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(23) "Trinity Properties, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6310.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1919"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1967"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(12) "Basement,Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Other"
  }
  ["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) "TRIP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(29) "antonet@trinityproperties.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 479-2089"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Antonet C Barut"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-04-19T14:24:01.260"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17918518"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-04-03T00:03:27.853"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26151287"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26151287"
    [1]=>
    string(8) "26151288"
    [2]=>
    string(8) "26151289"
    [3]=>
    string(8) "26151290"
    [4]=>
    string(8) "26151291"
    [5]=>
    string(8) "26151292"
    [6]=>
    string(8) "26151293"
    [7]=>
    string(8) "26151294"
    [8]=>
    string(8) "26151295"
    [9]=>
    string(8) "26151296"
    [10]=>
    string(8) "26151297"
    [11]=>
    string(8) "26151298"
    [12]=>
    string(8) "26151299"
    [13]=>
    string(8) "26151300"
    [14]=>
    string(8) "26151301"
    [15]=>
    string(8) "26151302"
    [16]=>
    string(8) "26151303"
    [17]=>
    string(8) "26151304"
    [18]=>
    string(8) "26151305"
    [19]=>
    string(8) "26151306"
    [20]=>
    string(8) "26151307"
    [21]=>
    string(8) "26151308"
    [22]=>
    string(8) "26151309"
    [23]=>
    string(8) "26151310"
    [24]=>
    string(8) "26151311"
    [25]=>
    string(8) "26151312"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202407509
        )

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

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

    [StreetName] => Array
        (
            [0] => Ala Noe
        )

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => MOANALUA VALLEY
        )

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to your dream home nestled in the highly desired Moanalua Valley.  This charming 4 bedroom, 2.5 bath residence boasts breathtaking mountain views and a large beautiful landscaped yard that is envied by neighbors.  This gorgeous home is move-in ready with a newly renovated kitchen featuring quartz counter tops, shaker cabinets, and newly installed luxury vinyl flooring that completes the look of this exceptional home.  BONUS FEATURE - a downstairs basement room complete with its own entrance and full bath, perfect for a guest room.  Situated in a prime location with easy access to the freeway and conveniently located near distinguished schools, hospitals, churches, golf course and parks.  You'll be minutes away from the airport, military bases  and shopping malls. Don't miss this opportunity to make this home your own!  Schedule a showing today!
        )

    [ListOfficeName] => Array
        (
            [0] => Trinity Properties, LLC
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Mountain,Other
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => antonet@trinityproperties.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 479-2089
        )

    [ListAgentFullName] => Array
        (
            [0] => Antonet C Barut
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-04-19T14:24:01.260
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-04-03T00:03:27.853
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26151287
            [1] => 26151288
            [2] => 26151289
            [3] => 26151290
            [4] => 26151291
            [5] => 26151292
            [6] => 26151293
            [7] => 26151294
            [8] => 26151295
            [9] => 26151296
            [10] => 26151297
            [11] => 26151298
            [12] => 26151299
            [13] => 26151300
            [14] => 26151301
            [15] => 26151302
            [16] => 26151303
            [17] => 26151304
            [18] => 26151305
            [19] => 26151306
            [20] => 26151307
            [21] => 26151308
            [22] => 26151309
            [23] => 26151310
            [24] => 26151311
            [25] => 26151312
        )

)

  • BedsTotal: 4
  • Full Baths: 2
  • Half Baths: 1
  • Land Area (sf): 6,310
  • Living (sf): 1,919
  • Year Built: 1967

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Mountain,Other
  • Listing Office: Trinity Properties, LLC

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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