Experience Peaceful, Private Living on 3.45 Acres with a Stocked
Pond in sought after Twelve Oaks Estates-Zoned to Prosper ISD and
Ideally Located in South Celina! This one-of-a-kind luxury estate
offers the perfect blend of refined living and wide-open space,
complete with a separate guest house and 5-car garage. A
spectacular drive-up sets the tone, as the main residence is
perfectly positioned overlooking a private pond with fountain,
surrounded by mature trees in a park-like setting. Designed for
both everyday comfort and exceptional entertaining, the home
showcases quality craftsmanship throughout, highlighted by
extensive custom millwork. The gourmet kitchen serves as the heart
of the home, seamlessly connecting the main family room featuring
floor-to-ceiling windows with breathtaking views of the
resort-style backyard to a secondary living area and media room,
creating an ideal layout for modern living. The primary suite is a
true retreat, offering a private sitting area with panoramic views
and a spa-inspired bath with generously sized his-and-hers closets.
A secondary bedroom with a full bath is also conveniently located
on the main level. Upstairs, an expansive landing opens to a
balcony overlooking the property, along with two spacious bedrooms,
each with ensuite baths, a versatile flex living space, and a
massive walk-out attic. Step outside to your own resort-style
paradise featuring a lagoon-style pool and spa, firepit, and an
octagonal covered gazebo with a stone fireplace and hearth.
Multiple patios provide ideal spaces for entertaining, while the
acreage offers room for horses, recreation, and fishing in your
private stocked pond. DaVinci 50-year Class IV roof, radiant
barrier for energy efficiency, and a recently upgraded deep well
for pond irrigation-delivering significant water savings. Situated
on an approximate 374' x 383' rare near-square interior lot. Please
see the attached list of recent updates and improvements!
Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.
How much can I actually make?
Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.
How is cap rate calculated?
Cap Rate = Net Operating Income (NOI) / Property Asset Value.
When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.
A Private Oasis in Twelve Oaks Estates: Your Yellowstone-Inspired Ranchette! This one of a kind Luxury Custom and Guest House - Peaceful and Private living in Twelve Oaks, situated on 3.45 acres with a private pond & fountain. Spectacular drive- up, as the main home, is perched over a beautiful private pond with fountain, a park-like setting surrounded by trees. From the full circle driveway, a hitch for your horses and stone steps lead up to the full covered porch and commanding double doors. Multi-Generational w Full Guest House in Twelve Oaks Estates on 3.45 acres. The Best of Both Worlds- living in south Celina and in Prosper ISD. Designed for Entertaining with a 1st Floor MEDIA includes screen, projector -as is- and has tiered stadium seating. The Living has 2 story high tall windows, stacked stone fireplace, flanked with stone shelves and a full bar. Appointed with custom millwork, moldings & polished concrete floors. Primary suite has a fireplace, exercise room. The spa-like Bath has vessel sinks, granite counters, huge shower, & sauna. The 2nd Bedroom down has a full bathroom. Upstairs leads to an amazing landing & balcony with two split Bedrooms each w ensuite baths,+ a fun Flex-living space. Resort living-lagoon Pool, Spa, Firepit, Octagonal covered Gazebo with a stone mantled fireplace and hearth Multiple patios, space for Horses to roam, kids to play soccer & fish at your private pond. MECHANICS: DaVinci 50 yr Roof Class IV Rating, Radiant in the attic for energy efficiency - main house. New Spa Heater installed - 2025, the private Pond- recently upgraded deep well for outdoor irrigation- a huge savings on water. Lot -3.45 acres - dimensions-374 ft x 383 ft, City of Celina Water and trash service for the home.
*Where else can you find a near square interior lot with 3.45 acres, with both a Luxury Home, Separate Guest House, Resort Pool, Spa Gazebo, plus allow Horses? It's all about the Land Celina & Prosper ISD - Walnut Grove High.
Feb 14, 2025
Delisted
-
Delisted
Feb 12, 2025
In contract
-
In contract
Oct 9, 2024
Price Decreased
$2,599,990
↓ $199K
(7.1%)
Price Decreased
Aug 16, 2024
Price Decreased
$2,799,000
↓ $200K
(6.7%)
Price Decreased
Jul 3, 2024
Price Decreased
$2,999,000
↓ $101K
(3.3%)
Price Decreased
Apr 18, 2024
Listed by Ebby Halliday, REALTORS
$3,100,000
Listed by Ebby Halliday, REALTORS
LEASE IN MLS AVAILABLE #20784643 Spectacular Multi-Gen w Full Guest House in Twelve Oaks Estates on3.45Acres. The Best of Both Worlds- living south Celina and in Prosper ISD. Amazing opportunity to own a Custom Luxury Home with a detached Guest House in prestigious Twelve Oaks Estates on 3.45 acres, a private Pond w fountain. Designed for Entertaining with a 1st Floor MEDIA incl screen, projector as is & stadium seating. The Living has 2 story high tall windows, stacked stone fireplace, wetbar. Appointed with custom millwork, moldings & polished concrete floors. Primary suite has a fireplace, exercise room. The spa-like Bath has vessel sinks, granite counters, huge shower, & sauna. The 2nd Bedroom down has a full bathroom. Upstairs leads to an amazing landing & balcony with Two split Bedrooms each w ensuite baths,+ a fun TV study-living. Resort living-lagoon Pool, Spa, Firepit,Gazebo & fireplace. Multiple patios, space for Horses to roam, kids to play soccer & fish at your private pond.Private & Peaceful- interior Sq Lot-3.45 acres,dimensions-374 ft x 383 ft. DIVINI Class IV-50 YR ROOF. *Where else can you find a near square interior lot with 3.45 acres, with both a Luxury Home, Separate Guest House,Resort Pool,Spa Gazebo, plus allow Horses? It's all about the Land Celina & Prosper ISD location*
Show More
Show Less
Property Highlights
Parking Available
Garage
Air Conditioning
Fireplace
Parking Details
Has Garage
Attached Garage
Parking Features: Additional Parking, Circular Driveway, Concrete, Covered, Driveway, Garage Door Opener, Garage Faces Rear, Garage Faces Side, Guest, Garage Double Door, Garage Single Door
Garage Spaces: 5
Interior Details
Half Bathrooms: 1
Full Bathrooms: 5
Interior Features: Built-in Features, Chandelier, Double Vanity, Dry Bar, Granite Counters, High Speed Internet, Kitchen Island, Natural Woodwork, Open Floorplan, Pantry, Sound System, Walk-In Closet(s), Wet Bar, Cable TV Available, Decorative Lighting, In-Law Suite Floorplan, Multiple Staircases, Paneling
Appliances: Built-In Gas Range, Built-In Refrigerator, Dishwasher, Disposal, Gas Water Heater, Ice Maker, Microwave, Double Oven, Refrigerator, Water Softener, Commercial Grade Range, Water Filter
Flooring Type: Carpet, Concrete, Hardwood, Tile, Wood, Travertine Stone
Laundry Features: Electric Dryer Hookup, Gas Dryer Hookup, Utility Room, Full Size W/D Area
Has Fireplace
Fireplace Features: Bedroom, Gas Log, Gas Starter, Insert, Living Room, Bedroom, Outside, Raised Hearth, Stone
Fireplaces: 3
Exterior Details
Square Footage: 7228
Security Features: Fire Alarm, Smoke Detector(s), Burglar
Year Built: 2003
Levels: Two
Other Structures: Cabana, Gazebo, Guest House, Residence, Second Residence, Separate Entry Quarters
Window Features: Bay Window(s), Shutters, Electric Shades
Patio and Porch Features: Covered, Front Porch, Rear Porch
Pool Features: Cabana, Fenced, Gunite, In Ground, Pool Cover, Pool Sweep, Pool/Spa Combo, Waterfall, Pump, Water Feature
Pool is Private
Lot Features: Corner Lot, Interior Lot, Landscaped, Many Trees, Acreage, Sprinkler System, Subdivision, Tank/ Pond, Water/Lake View
By proceeding, you consent to receive calls and texts at the number you provided, including marketing by autodialer and prerecorded and artificial voice, and email, from realtor.com and others about your inquiry and other home-related matters, but not as a condition of purchase (More...)California Privacy Notice
By submitting your information, you agree RealtyHop can share your information with its network of real estate &
mortgage professionals (or through their agents) and consent to receive marketing emails, calls, & texts related
to your inquiry (including via automatic telephone dialing system, or artificial or pre-recorded voice technology)
from Movoto or their affiliates to the email address or number you provided.
By proceeding, you agree to our Terms of Service. California Privacy Notice
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017