Sell Your Home
Get a free home valuation
Contact
Tell us about your needs

400 WATER STREET

House Recently Sold
$1,950,000

BTC: 30.46875000

ETH: 1,116.83848797

Sold on: 2020-12-23
49 days
Waterfront
5 bds
5 ba
5,124 sqft

Overview

Rare Iconic Main Village Mansion up for sale. The “Rosemount” is in a caliber all to its own, this Main Village Mansion designed after the Rosemount Mansion in Alabama ( which is on the Historic Preservation site) . This two lot estate has stopped many in its tracks as it is divine in every aspect situated with beautiful views of Picturesque Canal & Celebration Golf Club. Super Rare Opportunity to own two Estate Lots in the Main Village of Celebration (LOTS 103 & 104) The Elegant first floor master bedroom has a walk-in closet and en-suite Master Bath located off of private garden. The architecture details include exquisite Crown Moldings, Grand Staircase and Multiple Fireplaces. This One-of-a-kind home offers a Music Room, Library and Family Room with French doors leading to the massive covered Wrap Porch and Fountain Pool. The Guest Quarters have a Bedroom, Bath and Media/Game Room. Both the Dining Room and Living Room have Fireplaces! Multiple doors lead to an expansive Lawn ( lot size closer to 1/2 acre which is impossible to find in this Disney town) , Giant Shade Trees & perfect seating areas to extend your entertainment area. Spectacular 360 degree views of Celebration, EPCOT Spaceship Earth and the Disney Fireworks from the "crow's nest" Cupola. All bedrooms are massive in size and many offer gardens or balconies off of them ( 5 bedroom, 5 full bath and 1/2 bath). Greek Revival with columns that are to die for - stroll to downtown Celebration's specialty stores, fabulous restaurants, Starbucks, Ice cream Parlor and Michael Graves designed Post Office. This corner lot mansion is across the street from the Robert Trent Jones Sr and Jr golf course. Oversized 3 car garage and extra parking pad. This home is for the person looking for the best home, on the best lot and the best location. Gourmet kitchen and brick walled pool area with lush gardens.

Location

Details

Type:
Residential
Parking:
Alley Access / Garage Door Opener / Parking Pad
Year Built:
1997
Lot:
0.53 Acres
Heating:
Central / Electric / Zoned
Price/sqft:
$466
Cooling:
Zoned
HOA:
$488

Valuation

Our model vs. what's actually selling nearby.
Estimate
$1,669,000
$1.3M – $2.4M
Confidence Low
List vs. estimate
$721K above estimate
List $2,390,000 · +43.2%
Our model says this listing is priced above recent comparable activity. Room to negotiate.
Price per sq ft
$466
+17.3% vs. city median $397
Based on
6 MLS comparables
Median of recent comparable listings. Sold comps use closing price, active listings use list price.

Highlights

Annual tax
$19,752
2019
HOA
$487/qtr
Recreational Facilities
Pool
Gunite
View
Garden, Golf Course
Waterfront
Canal - Freshwater
Garage
3 car garage
Pets
Allowed
All facts and features
  • Flooring

    • Carpet

    • Ceramic Tile

    • Hardwood

    Heating

    • Central

    • Electric

    • Zoned

    Cooling

    • Zoned

    Appliances

    • Dishwasher

    • Disposal

    • Dryer

    • Electric Water Heater

    • Microwave

    • Range

    • Refrigerator

    • Washer

    Other interior features

    • Ceiling Fan(s)

    • Crown Molding

    • High Ceilings

    • Kitchen/Family Room Combo

    • Primary Bedroom Main Floor

    • Solid Wood Cabinets

    • Stone Counters

    • Thermostat

    • Walk-In Closet(s)

    • Window Treatments

    Bedrooms and bathrooms

    • Bedrooms: 5

    • Bathrooms: 1

    • Full bathrooms: 5

  • Parking

    • Alley Access

    • Garage Door Opener

    • Parking Pad

    Property

    • Levels: Two

    • Pool Private: Yes

    • Exterior Features: Balcony / French Doors / Irrigation System / Sidewalk / Sliding Doors / Sprinkler Metered

    Lot

    • Lot: 0.53 Acres

    Other Property Information

    • Parcel Number: 072528278300011040

    • Zoning: OPUD

  • Type and style

    • Property Type: Residential

    • Property Sub Type: Single Family Residence

  • Utility

    • BB/HS Internet Available

    • Cable Connected

    • Electricity Connected

    • Public

    • Sprinkler Meter

    • Sprinkler Recycled

    • Street Lights

    • Underground Utilities

  • Other financial information

    • HOA: $488

    • HOA Frequency: Quarterly

    • Annual tax amount: $19,752

  • Source details

    • MLS ID: O5892684

    Other facts

    • Construction Materials: Cement Siding

    • Foundation Details: Slab

    • Fireplace Features: Living Room / Other Room

    • Laundry Features: Inside

    • Lot Features: Corner Lot / Sidewalk / Street One Way

    • Patio And Porch Features: Covered / Deck / Front Porch / Patio / Porch

    • Pool Features: Gunite / In Ground

    • Window Features: Blinds / Window Treatments

    • Direction Faces: East

    • Architectural Style: Historical

    • Waterfront: Yes

    • Fireplace: Yes

    • Water Body Name: CELEBRATION MAIN VILLAGE CANAL

    • Garage Spaces: 3

    • Attached Garage: Yes

    • Garage: Yes

    • Living Area: 5124

    • Water Source: Public

    • Lot Size Dimensions: x

    • Subdivision Name: CELEBRATION

Private inquiry
Talk to the advisor on this listing.
Floor plans, HOA docs, off-market comparables, scheduling a private showing — one message, direct to the local specialist.

More like this

Recently Sold
$2,399,000
House
5 bds · 4 ba · 4,402 sqft
CELEBRATION VILLAGE UNIT 02, CELEBRATION
405 WATER STREET
Recently Sold
$2,300,000
House
6 bds · 6 ba · 6,493 sqft
CELEBRATION VILLAGE UNIT 02, CELEBRATION
808 GOLFPARK DRIVE
Recently Sold
$1,999,000
House
5 bds · 4 ba · 4,155 sqft
CELEBRATION EAST VILLAGE UNIT 3, CELEBRATION
764 OAK SHADOWS ROAD
Recently Sold
$2,100,000
House
5 bds · 3 ba · 4,695 sqft
CELEBRATION VILLAGE UNIT 2, CELEBRATION
514 GOLFPARK DRIVE
Recently Sold
$2,050,000
House
7 bds · 6 ba · 5,927 sqft
CELEBRATION VILLAGE UNIT 02, CELEBRATION
939 JASMINE ST
Recently Sold
$1,900,000
House
7 bds · 5 ba · 4,696 sqft
CELEBRATION NORTH VILLAGE UNIT 02, CELEBRATION
106 ACADIA TERRACE
New
Recently Sold
$1,850,000
House
5 bds · 5 ba · 4,514 sqft
CELEBRATION WEST VILLAGE, CELEBRATION
908 WESTPARK DRIVE
New
Recently Sold
$2,350,000
House
6 bds · 4 ba · 5,947 sqft
CELEBRATION VILLAGE UN #2, CELEBRATION
506 GOLFPARK DRIVE

Market around this address

Live counts in the same area.
View all

The multiple listing information is provided by the Stellar MLS from a copyrighted compilation of listings. The compilation of listings and each individual listing are ©2026-present Stellar MLS. All Rights Reserved. The information provided is for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All properties are subject to prior sale or withdrawal. All information provided is deemed reliable but is not guaranteed accurate, and should be independently verified. Listing courtesy of: FLORIDA IN MOTION REALTY INC