Skip main navigation
For sale
  • $3,559,000

    248 Piliwale Rd, Kula, HI 96790

    3beds
    2baths
    1,656sqft
    : 
    Single Family Residence, Residential
    Built in 1976
    4.5 Acres Lot
    $3,224,200 Zestimate®
    $2,149/sqft
    $-- HOA

    What's special

    Endless horticultural possibilities await on this rare AG-zoned, turnkey property, with the potential for SELLER FINANCING. Complete with a valuable 2-inch water meter, this operational property is full of opportunity. Enjoy the pleasant Kula country weather, breathtaking ocean and mountain views, and the ideal climate for cultivating your own future. Situated on 4.5 acres, the grounds are equipped with a variety of irrigated greenhouses, multiple accessory buildings, and two homes, perfect for both comfortable living or as caretaker's retreat. Recent upgrades include: state-of-the-art Fohse 06i grow lights, an automated irrigation and fertilization system, a custom ventilation and cooling system, new pollen screens, a CAT backup generator with a 2500 triple wall diesel gas tank, and updated electrical. This property is ready for seamless operation. With a successful history as a nursery and a fully licensed hemp farm, this property presents a unique business opportunity for a creative new buyer. Don't miss your chance to be a part of a thriving new enterprise.
    210 days
    |
    296
    |
    6
    |

    Zillow last checked: 7 hours ago

    Listing updated: August 18, 2025 at 10:05pm

    Listing Provided by:

    Evelyn Jaramillo RB-23900 Cell:808-294-0858,

    Coldwell Banker Island Prop(P),

    Will McKinney RS-68209 808-268-3917,

    Coldwell Banker Island Prop(S)

    Source: RAM,MLS#: 406880MLS Logo

    Tour with a local agent

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      Rooms
      • Room types: Workshop
      Primary bedroom
      • Level: Ground
      Appliances
      • Included: Dishwasher, Disposal, Dryer, Range, Refrigerator, Washer
      Features
      • Ceiling Fan(s), Storage
      • Has fireplace: Yes
      Interior area
      • Total structure area: 2,628
      • Total interior livable area: 1,656 sqft
      Video & virtual tour

      Property

      Parking
      • Parking features: No Garage
      Features
      • Exterior features: Lawn Sprinkler
      • Fencing: Wall/Fence
      • Has view: Yes
      • View description: Mountain/Ocean
      • Has water view: Yes
      • Water view: Mountain/Ocean
      • Waterfront features: None
      Lot
      • Size: 4.5 Acres
      Details
      • Parcel number: 2230031090000
      • Zoning description: Agricultural

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence, Residential
      Materials
      • Foundation: Pillar/Post/Pier
      • Roof: Shingle
      Condition
      • Year built: 1976

      Utilities & green energy

      • Electric: Overhead Electricity
      • Sewer: Cesspool
      • Water: Public

      Community & HOA

      Community
      • Subdivision: Rose Machado Estate Subdi
      Location
      • Region: Kula

      Financial & listing details

      • Price per square foot: $2,149/sqft
      • Tax assessed value: $1,157,800
      • Annual tax amount: $7,211
      • Date on market: 8/19/2025
      Get pre-qualifiedBe ready to make an offer.
      Connect with an agentGet info on this home, tour, and more.
      Calculate monthly paymentSee if you can afford this home.

        Estimated market value

        $3,224,200

        $3.06M - $3.39M

        $3,940/mo

        Price history

        Price history
        DateEventPrice
        8/19/2025Listed for sale$3,559,000-11%$2,149/sqft
        Source: RAM #406880 Report a problem
        5/3/2025Listing removed$3,999,000$2,415/sqft
        Source: RAM #400161 Report a problem
        12/13/2024Price change$3,999,000-10.9%$2,415/sqft
        Source: RAM #400161 Report a problem
        9/21/2024Price change$4,490,000-25.2%$2,711/sqft
        Source: RAM #400161 Report a problem
        11/3/2023Listed for sale$5,999,000-24.1%$3,623/sqft
        Source: RAM #400161 Report a problem
        10/20/2023Listing removed$7,900,000$4,771/sqft
        Source: RAM #398313 Report a problem
        9/27/2023Listed for sale$7,900,000$4,771/sqft
        Source: RAM #398313 Report a problem
        9/19/2023Listing removed$7,900,000$4,771/sqft
        Source: RAM #398313 Report a problem
        3/8/2023Listed for sale$7,900,000+618.2%$4,771/sqft
        Source: RAM #398313 Report a problem
        7/13/2015Sold$1,100,000+9%$664/sqft
        Source: RAM #365628 Report a problem
        3/13/2009Sold$1,009,400+20.9%$610/sqft
        Source: Public Record Report a problem
        5/15/2007Sold$835,000$504/sqft
        Source: Public Record Report a problem

        Public tax history

        Public tax history
        YearProperty taxesTax assessment
        2024$7,211 +1.9%$1,157,800 +0.4%
        2023$7,076 +51.8%$1,153,300 +44.8%
        2022$4,661 +19.4%$796,700 +11.2%
        2021$3,904 -4.6%$716,300 -0.3%
        2020$4,094 -4.9%$718,600 +4.3%
        2019$4,303 $689,200 -3.9%
        2018$4,303 +39.9%$717,200
        2017$3,077 -14.7%--
        2016$3,605 $639,900 +15.5%
        2015-- $554,000

        Find assessor info on the county website

        BuyAbility℠ payment

        Est. payment
        $18,798/mo
        Principal & interest
        $18353
        Property taxes
        $445
        More affordability tools

          Climate risks

          Neighborhood: 96790

          Getting around

          1 / 100
          Car-Dependent

          Nearby schools

          GreatSchools rating

          Local experts in 96790

          Similar homes

          Skip to the end of the carouselSkip to the beginning of the carousel