245 E 24th Street Upland, CA 91784
Listing Courtesy of: CRMLS / Century 21 Peak / Sharon Kobold - 909-228-3336
$4,129,000
6
BED
7
BATH
7,004
SQFT

  245 E 24th Street Upland, CA 91784

Pending (235 Days)

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!

MLS #:
CV23057695
Lot Size
1.11 acres
Type
Single-Family Home
Year Built
2005
Style
Mediterranean, Custom
Views
Valley, City Lights, Panoramic, Mountain(s)
School District
Upland
County
San Bernardino County
Bathroom Details
  • Full Bathrooms: 6
  • Half Bathroom: 1
Interior Features
  • Windows: Drapes
  • Windows: Screens
  • Windows: Plantation Shutters
  • Windows: Custom Covering(s)
  • Water Softener
  • Warming Drawer
  • Trash Compactor
  • Refrigerator
  • Range Hood
  • Microwave
  • Ice Maker
  • Gas Range
  • Gas Oven
  • Freezer
  • Disposal
  • Dishwasher
  • 6 Burner Stove
  • Laundry: Washer Hookup
  • Laundry: Gas Dryer Hookup
  • Laundry: Inside
  • Laundry: Laundry Room
  • Laundry: See Remarks
  • Unfurnished
  • Tray Ceiling(s)
  • Sunken Living Room
  • Recessed Lighting
  • Primary Suite
  • Pantry
  • Paneling/Wainscoting
  • Open Floorplan
  • Multiple Staircases
  • High Ceilings
  • Granite Counters
  • Dumbwaiter
  • Crown Molding
  • Coffered Ceiling(s)
  • Central Vacuum
  • Ceiling Fan(s)
  • Cathedral Ceiling(s)
  • Built-In Features
  • Bedroom on Main Level
  • Bar
  • Balcony
Lot Information
  • Street Level
  • Sprinklers Timer
  • Sprinklers In Rear
  • Sprinklers In Front
  • Sprinkler System
  • Rectangular Lot
  • Lot Over 40000 Sqft
  • Level
  • Lawn
  • Landscaped
  • Garden
  • Front Yard
  • Back Yard
Property Features
  • Fireplace: Primary Bedroom
  • Fireplace: Outside
  • Fireplace: Living Room
  • Fireplace: Raised Hearth
  • Fireplace: See Remarks
  • Fireplace: Family Room
  • Fireplace: See Through
Heating and Cooling
  • Central
  • Central Air
  • Dual
Pool Information
  • Private
  • Waterfall
  • In Ground
  • See Remarks
Flooring
  • Laminate
  • Carpet
  • Tile
  • Wood
  • See Remarks
  • Stone
Exterior Features
  • Roof: Tile
  • Roof: Clay
Utility Information
  • Utilities: Water Source: Private, Electricity Available, Sewer Not Available, Water Available, Water Connected, See Remarks, Electricity Connected, Natural Gas Available, Natural Gas Connected
  • Sewer: Septic Tank
School Information
  • Elementary School: Valencia
  • Middle School: Pioneer
  • High School: Upland
Parking
  • See Remarks
  • Rv Potential
  • Rv Access/Parking
  • Private
  • Oversized
  • Gated
  • Garage Faces Side
  • Garage
  • Driveway Level
  • Driveway
  • Door-Multi
  • Direct Access
  • Controlled Entrance
  • Concrete
Stories
  • 2
Living Area
  • 7,004 sqft
Additional Listing Info
  • Buyer Brokerage Commission: 2.500
Location
   
Calculate drive times to this property
 

Listing Price History

Date
Event
Price
% Change
$ (+/-)
Oct 13, 2023
Price Changed
$4,129,000
-1%
-48,000
Apr 08, 2023
Original Price
$4,177,000
-
-

Estimated Monthly Mortgage Payment

*Based on Fixed Interest Rate withe a 30 year term, principal and interest only

Listing price
Down payment
%
Interest rate
%
Mortgage calculator estimates are provided by CENTURY 21 Real Estate LLC and are intended for information use only. Your payments may be higher or lower and all loans are subject to credit approval.
Disclaimer: Based on information from California Regional Multiple Listing Service, Inc. as of 2/22/23 10:28 and /or other sources. Display of MLS data is deemed reliable but is not guaranteed accurate by the MLS. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent. The information being provided by Conejo Simi Moorpark Association of REALTORS® (“CSMAR”) is for the visitor's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. Any information relating to a property referenced on this web site comes from the Internet Data Exchange (“IDX”) program of CSMAR. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. Any information relating to a property, regardless of source, including but not limited to square footages and lot sizes, is deemed reliable.