512 Water St, Unit 512

1,214 Sq. Ft.
$317 / Sq. Ft.
1,214
Sq. Ft.
$317
per Sq. Ft.

Description

Perfectly positioned in the heart of Celebration’s Main Village, this beautifully updated 2-bedroom, 2-bath second-floor end-unit condo offers the ideal blend of style, comfort, and convenience. Renovated in 2022 with over $65,000 in thoughtful improvements, this penthouse-style residence lives large thanks to soaring vaulted ceilings, an airy open-concept living and dining space, and abundant natural light streaming through double-pane windows. The stunning kitchen is open to the main living area...Perfectly positioned in the heart of Celebration’s Main Village, this beautifully updated 2-bedroom, 2-bath second-floor end-unit condo offers the ideal blend of style, comfort, and convenience. Renovated in 2022 with over $65,000 in thoughtful improvements, this penthouse-style residence lives large thanks to soaring vaulted ceilings, an airy open-concept living and dining space, and abundant natural light streaming through double-pane windows. The stunning kitchen is open to the main living area and features stainless steel appliances, a smooth-top range, stone backsplash, upgraded cabinetry, and modern finishes that make everyday living and entertaining effortless. Enjoy your morning coffee or evening glass of wine from the private balcony overlooking Mulberry Avenue, with lovely views of picturesque Savannah Square and the scenic canal along Celebration’s Esplanade—leading you directly to Downtown Celebration just one block away. Both bathrooms were fully renovated with comfort-height vanities and toilets, with a tub/shower combination in the guest bath and a spacious walk-in shower in the primary suite. Additional highlights include crown molding, LED lighting throughout, blinds on every window with automatic upper blinds, newer LG washer and dryer, a convenient storage closet adjacent to the front door, concierge trash service, and two parking decals for easy resident parking. This meticulously maintained building also received a fresh exterior paint update and new roof in 2025, adding long-term value and peace of mind. Residents of Celebration enjoy a one-of-a-kind small-town atmosphere with lakeside dining, boutiques, coffee shops, community events, a Sunday farmers market, tennis courts, playgrounds, resort-style pools, dog parks and over 26 miles of scenic walking and biking trails—all just minutes from Walt Disney World Resort and Orlando’s world-famous attractions. This is downtown Celebration living at its absolute finest.
  1. Listed by Jennifer Schreiber • Brokerage DRE #1033550 • IMAGINATION REALTY, INC
    P: (407)-973-5575 C: (407)-973-5575 jennifer@imaginationrealty.net

Property Details for 512 Water Street, Unit 512

Architectural Style
Historical, Traditional
Subdivision Name
WATER STREET CONDO PH 04
Township
25
Waterfront
No
Furnished
Unfurnished
LISTING UPDATED: 05/18/2026 04:04 PM

Property Details for 512 Water Street, Unit 512

StatusPending
MLS #S5148526
Days on Market7
Pet PolicyAllowed
Taxes$4,877 / year
HOA Fees$357 / quarter
Condo/Co-op Fees$565 / month
Property TypeCondo
MLS TypeResidential / Condominium
Year Built1998
CountyOsceola County

Location

Listing Courtesy of IMAGINATION REALTY, INC, Jennifer Schreiber
Add your commute

Building Information for 512 Water Street, Unit 512

Building/Complex512 Water StFloor-Stories1Residences-Pet PolicyAllowedPet Policy DetailsYesYear Built1998

Payment Calculator

$3,009 per month

30 year fixed, 6.36% Interest

Principal and Interest

$1,918

Property Taxes

$406

HOA Dues

$684

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 512 Water Street, Unit 512

Summary
Location and General Information
  • Building Area Source: Public Records
  • Building Area Total: 1232.0
  • Building Area Units: Square Feet
  • Building Name Number: FARMINGTON / 6
  • Community Features: Lake, Association Recreation - Owned, Deed Restrictions, Dog Park, Fitness Center, Irrigation-Reclaimed Water, Park, Playground, Pool, Special Community Restrictions, Tennis Court(s)
  • Direction Faces: Southeast
  • Directions: I-4 to US 192 (Exit 64 toward Kissimmee), Right onto Celebration Ave. turn Right on Waterstreet, take next Left over the bridge on Mulberry, Unit is on the Left (second floor).
  • Elementary School: Celebration K-8
  • Middle Or Junior School: Celebration K-8
  • High School: Celebration High
  • Floor Number: 2
  • Mls Major Change Type: Pending
  • Major Change Type: Pending
  • Listing Service: Full Service
  • Road Frontage Type: Street Paved
  • Senior Community: No
  • Unit Number: No
  • Street Number: 512
  • Street Name: WATER
  • Street Suffix: STREET
  • Unit Number: 512
  • State: FL
  • City: CELEBRATION
Parking
  • Carport: No
  • Garage: No
  • Parking Features: None, On Street, Open
Taxes and HOA Information
  • Association Approval Required: No
  • Association Fee Includes: Escrow Reserves Fund, Insurance, Maintenance Structure, Maintenance Grounds, Pest Control, Trash
  • Association Fee Requirement: Required
  • Association Name: CROA /Daniel Medina
  • Association Phone: 321-939-2021
  • Association: Yes
  • CDD: Yes
  • Condo Land Included: No
  • Montly Maint Amt Addition To HOA: $0
  • Number Of Pets: 2
  • Pet Restrictions: Buyers to verify with condo rules and regulations.
  • Pet Size: Extra Large (101+ Lbs.)
  • Tax Block: 1
  • Tax Book Number: 4-72
  • Tax Legal Description: WATER STREET CONDO PH 4 CB 4 PG 72-79 UNIT 512
  • Tax Lot: 5120
  • Tax Other Annual Assessment Amt: $440
  • Tax Year: 2025
Property
Lot Information
  • Additional Parcels: No
  • Lot Features: Corner Lot, Level, Sidewalk, Unincorporated
  • Parcel Number: 072528542300015120
  • Total Acreage: 0 to less than 1/4
  • Water Access: No
  • Water Body Name: WATER STREET CANAL
  • Water Extras: No
  • Zoning: OPUD
  • Zoning Compatible: Yes
  • Living Area: 1214
  • Property Info: End Unit
Property and Assessments
  • Year Built Numeric: 1998
  • Association Amenities: Fitness Center, Vehicle Restrictions
  • Building Elevator: No
  • Flood Zone Code: X
  • Flood Zone Date: 06-18-2013
  • Flood Zone Panel: 12097C0035G
  • Home Warranty: No
  • Homestead: No
  • New Construction: No
  • Property Condition: Completed
  • Public Survey Range: 28
  • Public Survey Section: 7
Utilities
  • Green Water Conservation: Irrigation-Reclaimed Water
  • Sewer: Public Sewer
  • Utilities: BB/HS Internet Available, Cable Available, Electricity Connected, Fiber Optics, Sewer Connected, Street Lights, Underground Utilities, Water Connected
  • Water Source: Public
Interior and Exterior Features
Exterior Features
  • Builder Model: B-3
  • Construction Materials: Stucco, Wood Frame
  • Exterior Features: Balcony, Irrigation System, Rain Gutters, Storage
  • Foundation Details: Slab
  • Levels: One
  • Other Structures: Storage
  • Pool Private: No
  • Pool: Community
  • Pool Private: Yes
  • Roof: Built-Up
  • Security Features: Fire Sprinkler System, Security System Owned, Smoke Detector(s)
  • Spa: No
  • Vegetation: Mature Landscaping, Trees/Landscaped
  • Waterfront Features: Lake
  • Waterfront Feet Total: 0
  • Number Of Stories: 1
Interior Features
  • Bedrooms Total: 2
  • Bathrooms Full: 2
  • Additional Rooms: Inside Utility
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer
  • Cooling: Central Air
  • Fireplace: No
  • Flooring: Carpet, Ceramic Tile
  • Heating: Central, Electric, Heat Pump
  • Interior Features: Cathedral Ceiling(s), Ceiling Fan(s), Crown Molding, High Ceilings, Open Floorplan, Walk-In Closet(s), Window Treatments
  • Laundry Features: Inside, Laundry Closet
  • Living Area Source: Public Records
  • Living Area Units: Square Feet
  • Room Count: 4.0
  • Water View: No
  • Window Features: Blinds, Thermal Windows, Window Treatments
  • Bathrooms Half: 0
Rental
Rental Information
  • Minimum Lease Period: 0
  • Pets Allowed: Yes
  • Max Pet Weight: 999

Property History for 512 Water Street, Unit 512

DateEvent & SourcePriceAppreciation
May 18, 2026

Pending

MFRMLS #S5148526

—
May 11, 2026

Listed (Active)

MFRMLS #S5148526

—
Apr 27, 2026

Pending

MFRMLS #S5148526

—
DateEvent & SourcePrice
05/18/2026

Pending

MFRMLS #S5148526

—
05/11/2026

Listed (Active)

MFRMLS #S5148526

—
04/27/2026

Pending

MFRMLS #S5148526

—

For completeness, we often displays two records for one sale: the MLS record and the public record.

Schools near 512 Water Street, Unit 512

This home is within The School District of Osceola County.
Rating
School
Type
Grades
Distance
Charter - K to 8
Public - 7 to 12
Public - 9 to 12
Charter - K to 8
Rating
School
Distance
Mater Palms Academy
CharterK to 8

Oasis Residential Center
Public7 to 12

Celebration High School
Public9 to 12

Renaissance Charter School At Poinciana
CharterK to 8

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of IMAGINATION REALTY, INC, Jennifer Schreiber

The information being provided by MFRMLS and Daytona Multiple Listing Service is for the consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the consumer may be interested in purchasing. Any information relating to real estate for sale referenced on this web site comes from the Internet Data Exchange (IDX) program of MFRMLS or Daytona Multiple Listing Service. Real estate listings held by brokerage firms other than this site owner are marked with the IDX/MLS logo. Information deemed reliable but is not guaranteed accurate by MFRMLS or Daytona Multiple Listing Service. Last updated: 05/18/2026 04:04 PM