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.
For sale
$3,559,000
248 Piliwale Rd, Kula, HI 96790
3beds
2baths
1,656sqft
Est.:
Single Family Residence, Residential
Built in 1976
4.5 Acres Lot
$3,204,300 Zestimate®
$2,149/sqft
$-- HOA
What's special
- 137 days |
- 201 |
- 11 |
Zillow last checked: 8 hours ago
Listing updated: August 18, 2025 at 10:05pm
Listing Provided by:
Evelyn Jaramillo RS-80432 Cell:808-294-0858,
Coldwell Banker Island Prop(P),
Will McKinney RS-68209 808-268-3917,
Coldwell Banker Island Prop(S)
Source: RAM,MLS#: 406880
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
Estimated market value
$3,204,300
$3.04M - $3.36M
$4,170/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 8/19/2025 | Listed for sale | $3,559,000-11%$2,149/sqft |
Source: | ||
| 5/3/2025 | Listing removed | $3,999,000$2,415/sqft |
Source: | ||
| 12/13/2024 | Price change | $3,999,000-10.9%$2,415/sqft |
Source: | ||
| 9/21/2024 | Price change | $4,490,000-25.2%$2,711/sqft |
Source: | ||
| 11/3/2023 | Listed for sale | $5,999,000-24.1%$3,623/sqft |
Source: | ||
Public tax history
Public tax history
| Year | Property taxes | Tax 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% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$19,222/mo
Principal & interest
$17531
Home insurance
$1246
Property taxes
$445
Climate risks
Neighborhood: 96790
Nearby schools
GreatSchools rating
- 7/10Kula Elementary SchoolGrades: PK-5Distance: 2.9 mi
- 5/10Samuel Enoka Kalama Intermediate SchoolGrades: 6-8Distance: 3.7 mi
- 5/10King Kekaulike High SchoolGrades: 9-12Distance: 2.1 mi
- Loading
- Loading





