Skip To Content

245 E 24th Street

Upland, CA 91784
  • $4,177,000
  • STATUS: Active
  • ON SITE: 173 Days
  • ID#: CV23057695
UPDATED: 39 min ago
$4,177,000
  • 6
    BEDS
  • 1.11
    ACRES
  • 6
    BATHS
  • 1
    1/2 BATHS
  • 7,004
    SQFT
  • $596
    $/SQFT
Neighborhood:
Type:
Single-Family Home
Built:
2005
County:
Area:

School Information

Elementary School:
Middle School:
High School:
School District:
Listing Agent(s): Sharon Kobold of Century 21 Peak (909-985-4600) and Steven Kobold of Century 21 Peak(909-985-4600)


Description

OPPORTUNITY OF A LIFETIME TO BECOME THE NEW HOMEOWNER OF "VILLA ARIES", AN ABSOLUTELY STUNNING MEDITERRANEAN CUSTOM ESTATE VILLA LOCATED IN THE EXCLUSIVE AREA OF SAN ANTONIO HEIGHTS! THIS EXTRAVAGANT ESTATE HAS BEEN METICULOUSLY DESIGNED TO PERFECTION & WILL CHECK OFF ALL THE BOXES. UNOBSTRUCTED VIEWS OF THE SAN GABRIEL MOUNTAINS & BEYOND FROM YOUR INCREDIBLE BACKYARD & UPSTAIRS BALCONY! GORGEOUS CITY LIGHTS & VALLEY VIEWS OFF YOUR PRIMARY SUITE UPSTAIRS BALCONY! DRAMATIC FORMAL ENTRY, IMPRESSIVE CUSTOM CIRCULAR BAR, FORMAL DINING RM, AND SPACIOUS FORMAL LIVING RM AWAITS YOU! JAW DROPPING SOARING TRAY CEILINGS, CROWN MOLDINGS, GLASS WINDOWS FROM FLOOR TO CEILING, SPECTACULAR MOUNTAIN & BACKYARD VIEWS, CUSTOM FIREPLACE, MARBLE FLOORS, CUSTOM BUILT-IN CREDENZA, FRENCH DOORS, AND CUSTOM INTERIOR COLORS & TEXTILES. AN UNBELIEVABLE DREAM KITCHEN YOU WILL ABSOLUTELY LOVE! CUSTOM CABINETS, GRANITE COUNTERS, SUB-ZERO, DBLE SINKS, DISHWASHERS & WARMING DRAWERS, TRASH COMPACTOR, 6 BURNER RANGE W/DBLE OVENS & GRILL, ADD'L OVEN, MICROWAVE, WALK IN PANTRY, BREAKFAST NOOK, LARGE & LONG BREAKFAST COUNTER-SEPARATE FROM CENTER ISLAND, AND POLISHED TRAVERTINE FLOORS. AMAZING! ALL OPEN TO YOUR EXPANSIVE FAMILY RM W/SOARING CEILINGS, CUSTOM BUILT-IN ENTERTAINMENT CENTER, LOTS OF WINDOWS, FRENCH DRS, & GORGEOUS FIREPLACE! EXECUTIVE OFFICE W/PRIVATE PATIO, GAME/POOL TABLE RM W/BUILT-INS, BAR, SINK, & FRIDGE, & YOUR EXCLUSIVE WINE CELLAR TASTING RM DOWNSTAIRS FOR ENTERTAINING! ENORMOUS LAUNDRY RM DOWNSTAIRS W/SINK, BUILT-INS, & DUMBWAITER + 3 BDRMS & 3.5 BTHRMS DOWNSTAIRS OF WHICH 2 BDRMS ARE ENSUITE BDRMS W/OWN SEPARATE BTHRMS. UPSTAIRS FEATURES ELEGANT PRIMARY SUITE W/RETREAT W/DBLE DOOR ENTRY, DBLE SIDED FIREPLACE, BUILT-INS W/FRIDGE, SINK, MICROWAVE, & COMPUTER AREA, PRIMARY ENSUITE BTHRM W/MARBLE FLOORS, DBLE SINK COUNTER AREAS, VANITY, JETTED TUB, WALK-IN STEAM SHOWER, SAUNA, WALK-IN CLOSET(S), & SLIDERS TO FRONT & BACKYARD BALCONIES. 2 ADD'L BDRMS BOTH W/ENSUITE BTHRMS. MASSIVE ENTERTAINERS BACKYARD W/FOUNTAINS, POOL/SPA, COVERED OUTDOOR KITCHEN/BAR, OUTDOOR COVERED LANAI W/FABULOUS SITTING AREA & LARGE FIREPLACE, FRUIT TREES OF EVERY KIND, SPORTS COURT, GAZEBO(S), ETC. HOSTING FAMILY & FRIENDS NEVER LOOKED & FELT SO GOOD! ALL SECURITY MEASURES HAVE BEEN TAKEN STARTING WITH THE BEAUTIFULLY DESIGNED WROUGHT IRON SECURITY ENTRANCE GATES TO EXTERIOR & INTERIOR SECURITY CAMERAS TO BURGLAR AND FIRE ALARM SYSTEM. 4 CAR GARAGE, RV PKING,& FRONT VINEYARD! INCREDIBLE OPPORTUNITY!

Monthly Payment Calculator



Based on information from California Regional Multiple Listing Service, Inc. as of 2023-09-30T18:33:27.28. This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is deemed reliable but is not guaranteed accurate by the MLS or Mainstreet Realtors®. Licensed in the State of California, USA.
www.mainstreetgroup.com/homes/138406186
Print Image

245 E 24th Street Upland, CA 91784

  • Price: $4,177,000
  • Status: Active
  • On Site: 173 Days
  • Updated: 39 min ago
  • ID#: CV23057695
6
Beds
6
Baths
1
½ Baths
1.11
Acres
7,004
SQFT
$596
$/SQFT
2005
Built
Neighborhood:
690 - Upland
County:
San Bernardino
Area:
690 - Upland
Elementary School:
Valencia
Middle School:
Pioneer
High School:
Upland
School District:
Upland
Property Description
OPPORTUNITY OF A LIFETIME TO BECOME THE NEW HOMEOWNER OF "VILLA ARIES", AN ABSOLUTELY STUNNING MEDITERRANEAN CUSTOM ESTATE VILLA LOCATED IN THE EXCLUSIVE AREA OF SAN ANTONIO HEIGHTS! THIS EXTRAVAGANT ESTATE HAS BEEN METICULOUSLY DESIGNED TO PERFECTION & WILL CHECK OFF ALL THE BOXES. UNOBSTRUCTED VIEWS OF THE SAN GABRIEL MOUNTAINS & BEYOND FROM YOUR INCREDIBLE BACKYARD & UPSTAIRS BALCONY! GORGEOUS CITY LIGHTS & VALLEY VIEWS OFF YOUR PRIMARY SUITE UPSTAIRS BALCONY! DRAMATIC FORMAL ENTRY, IMPRESSIVE CUSTOM CIRCULAR BAR, FORMAL DINING RM, AND SPACIOUS FORMAL LIVING RM AWAITS YOU! JAW DROPPING SOARING TRAY CEILINGS, CROWN MOLDINGS, GLASS WINDOWS FROM FLOOR TO CEILING, SPECTACULAR MOUNTAIN & BACKYARD VIEWS, CUSTOM FIREPLACE, MARBLE FLOORS, CUSTOM BUILT-IN CREDENZA, FRENCH DOORS, AND CUSTOM INTERIOR COLORS & TEXTILES. AN UNBELIEVABLE DREAM KITCHEN YOU WILL ABSOLUTELY LOVE! CUSTOM CABINETS, GRANITE COUNTERS, SUB-ZERO, DBLE SINKS, DISHWASHERS & WARMING DRAWERS, TRASH COMPACTOR, 6 BURNER RANGE W/DBLE OVENS & GRILL, ADD'L OVEN, MICROWAVE, WALK IN PANTRY, BREAKFAST NOOK, LARGE & LONG BREAKFAST COUNTER-SEPARATE FROM CENTER ISLAND, AND POLISHED TRAVERTINE FLOORS. AMAZING! ALL OPEN TO YOUR EXPANSIVE FAMILY RM W/SOARING CEILINGS, CUSTOM BUILT-IN ENTERTAINMENT CENTER, LOTS OF WINDOWS, FRENCH DRS, & GORGEOUS FIREPLACE! EXECUTIVE OFFICE W/PRIVATE PATIO, GAME/POOL TABLE RM W/BUILT-INS, BAR, SINK, & FRIDGE, & YOUR EXCLUSIVE WINE CELLAR TASTING RM DOWNSTAIRS FOR ENTERTAINING! ENORMOUS LAUNDRY RM DOWNSTAIRS W/SINK, BUILT-INS, & DUMBWAITER + 3 BDRMS & 3.5 BTHRMS DOWNSTAIRS OF WHICH 2 BDRMS ARE ENSUITE BDRMS W/OWN SEPARATE BTHRMS. UPSTAIRS FEATURES ELEGANT PRIMARY SUITE W/RETREAT W/DBLE DOOR ENTRY, DBLE SIDED FIREPLACE, BUILT-INS W/FRIDGE, SINK, MICROWAVE, & COMPUTER AREA, PRIMARY ENSUITE BTHRM W/MARBLE FLOORS, DBLE SINK COUNTER AREAS, VANITY, JETTED TUB, WALK-IN STEAM SHOWER, SAUNA, WALK-IN CLOSET(S), & SLIDERS TO FRONT & BACKYARD BALCONIES. 2 ADD'L BDRMS BOTH W/ENSUITE BTHRMS. MASSIVE ENTERTAINERS BACKYARD W/FOUNTAINS, POOL/SPA, COVERED OUTDOOR KITCHEN/BAR, OUTDOOR COVERED LANAI W/FABULOUS SITTING AREA & LARGE FIREPLACE, FRUIT TREES OF EVERY KIND, SPORTS COURT, GAZEBO(S), ETC. HOSTING FAMILY & FRIENDS NEVER LOOKED & FELT SO GOOD! ALL SECURITY MEASURES HAVE BEEN TAKEN STARTING WITH THE BEAUTIFULLY DESIGNED WROUGHT IRON SECURITY ENTRANCE GATES TO EXTERIOR & INTERIOR SECURITY CAMERAS TO BURGLAR AND FIRE ALARM SYSTEM. 4 CAR GARAGE, RV PKING,& FRONT VINEYARD! INCREDIBLE OPPORTUNITY!
Exterior Features

Architectural Style CustomMediterranean Attached Garage YN Yes Construction Materials FrameStucco Direction Faces South Entry Location With Steps Exterior Features BarbecueLightingRain GuttersSport Court Fencing SecuritySee RemarksStucco WallWrought Iron Lot Features Back YardFront YardGardenSprinklers In RearSprinklers In FrontLawnLot Over 40000 SqftLandscapedLevelRectangular LotSprinklers TimerSprinkler SystemStreet Level Other Structures Gazebo Parking Features Controlled EntranceConcreteDoor-MultiDirect AccessDriveway LevelDrivewayGarageGatedOversizedPrivateRv PotentialRv Access/ParkingGarage Faces SideSee Remarks Parking Total 4 Patio And Porch Features ConcreteCoveredPatioSee Remarks Pool Features In GroundPrivateSee RemarksWaterfall Pool Private YN Yes Property Attached YN No Road Frontage Type City Street Roof ClayTile Sign On Property YN Yes Spa Features In GroundPrivate Spa YN Yes View City LightsMountain(S)PanoramicValley View YN Yes

Interior Features

Appliances 6 Burner StoveDishwasherFreezerDisposalGas OvenGas RangeIce MakerMicrowaveRefrigeratorRange HoodWater SoftenerTrash CompactorWarming Drawer Common Walls No Common Walls Cooling Central AirDual Cooling YN Yes Door Features Double Door EntryFrench DoorsMirrored Closet Door(S)Panel DoorsSliding Doors Fireplace Features Family RoomLiving RoomMaster BedroomOutsideRaised HearthSee ThroughSee Remarks Fireplace YN Yes Flooring CarpetLaminateSee RemarksStoneTileWood Heating Central Heating YN Yes Interior Features Built-In FeaturesBalconyTray Ceiling(S)Ceiling Fan(S)Crown MoldingCathedral Ceiling(S)Central VacuumCoffered Ceiling(S)DumbwaiterGranite CountersHigh CeilingsMultiple StaircasesOpen FloorplanPantryPaneling/WainscotingRecessed LightingSunken Living RoomUnfurnishedBarBedroom On Main LevelWalk-In Pantry Main Level Bathrooms 3 Main Level Bedrooms 3 Window Features Custom Covering(S)DrapesPlantation ShuttersScreens

Property Features

Additional Parcels YN No Association Fee 0 Association YN No Common Interest None Community Features Suburban Contingency None Garage YN Yes Inclusions Solar Paid In Full1/2 Share San Antonio Water Stock Land Lease YN No Laundry Features Washer HookupGas Dryer HookupInsideLaundry RoomSee Remarks Lease Considered YN No Levels Two Listing Agreement Exclusive Right To Sell Listing Service Full Service Listing Terms CashCash To New Loan New Construction YN No Other Equipment Intercom Possession Close Plus 3 Days Property Condition Turnkey Property Sub Type Single Family Residence Security Features PrewiredSecurity SystemCarbon Monoxide Detector(S)Smoke Detector(S) Senior Community YN No Sewer Septic Tank Special Listing Conditions Standard Structure Type House Utilities Electricity AvailableElectricity ConnectedNatural Gas AvailableNatural Gas ConnectedSewer Not AvailableSee RemarksWater AvailableWater Connected Water Source Private Zoning Rs-14M



Based on information from California Regional Multiple Listing Service, Inc. as of 2023-09-30T18:33:27.28. This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is deemed reliable but is not guaranteed accurate by the MLS or Mainstreet Realtors®. Licensed in the State of California, USA.
 
https://bt-photos.global.ssl.fastly.net/socal/orig_boomver_1_371215238-2.jpg https://bt-photos.global.ssl.fastly.net/socal/orig_boomver_1_371215238-2.jpg https://bt-photos.global.ssl.fastly.net/socal/orig_boomver_1_371215238-2.jpg
Logo
Mainstreet Realtors®
8577 Haven Ave, Suite 100
Rancho Cucamonga CA, 91730
Listing Agent(s): Sharon Kobold of Century 21 Peak (909-985-4600) and Steven Kobold of Century 21 Peak(909-985-4600)