x
Showing 1 of 0
X
Save

6243 Rosewood Court
Mission KS 66205 US

$525,000

Active Listing ID 2621550
bed icon
3 bed
bath icon
4.00 Bath (3 Full , 2 Half)
lot icon
Lot: 0.04 Acres
home icon
Condominium

$525,000

Active Listing ID 2621550
Save

6243 Rosewood Court Show-Stopping Luxury Meets Carefree Villa Living Prepare to be captivated by this masterfully reimagined story-and-a-half townhome in the highly coveted Lido Villas. Soaring, sun-drenched ceilings and a sweeping expanse of rich hardwood floors welcome you into a space designed to impress. The heart of the home features a stunning, state-of-the-art chef's kitchen and an opulent new primary suite complete with a spa-inspired bath. Entertainment options abound in the newly refinished lower level, boasting a massive recreation room, a private home office, a full secondary kitchen, and a convenient half bath. Step outside to your own private oasis-a rare, beautifully landscaped patio with a grassed area perfect for pets or play. Complete with exclusive access to the premier clubhouse and sparkling pool, this turnkey masterpiece offers a sophisticated lifestyle that is second to none. HOA fee is $524mo. and Pool Fee is 56mo.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.04 Acres
  • Property Type: Residential
  • Property Sub-type: Condominium
  • Features
  • Full Bathrooms: 3
  • 1/2 Bathrooms: 2
  • Cooling System: Electric
  • Floor Covering: Wood, Carpet
  • Roof Type: Composition
  • Heating Fuels: Forced Air
  • Additional Features
  • Basement
  • Fireplace
  • Patio

School Information

  • School
  • Highlands(Elementary)
  • Indian Hills(MiddleSchool)
  • SM East(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Condominium
  • listprice: 525000
  • unparsedaddress: 6243 Rosewood Court
  • postalcity: Mission
  • stateorprovince: KS
  • country: US
  • postalcode: 66205
  • bathroomsfull: 3
  • bathroomshalf: 2
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.04
  • lotsizeunits: Acres
  • lotsizearea: 0.04
  • livingarea: 3652
  • livingareaunits: Square Feet
  • latitude: 39.015905
  • longitude: -94.645768
  • listagentfullname: David Costello
  • listagentemail: dcostello@remax.net
  • listagentkey: 3yd-HMLSKS-COSTELDA
  • listagentmlsid: COSTELDA
  • listagentpreferredphone: 8165913186
  • listagentofficephone: 9136520400
  • listofficekey: 3yd-HMLSKS-RMX_40
  • listofficemlsid: RMX_40
  • disclaimer: Copyright © 2026 Heartland Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: HMLSKS
  • yearbuilt: 1984
  • listingcontractdate: 2026-05-22
  • listagentfax: 9139011501
  • listagenturl: http://www.costellorealestate.com
  • countyorparish: Johnson, KS
  • parcelnumber: KP1900B10B 0U53
  • elementaryschool: Highlands
  • highschool: SM East
  • elementaryschooldistrict: Shawnee Mission
  • middleorjuniorschooldistrict: Shawnee Mission
  • highschooldistrict: Shawnee Mission
  • appliances: Dishwasher, Disposal, Refrigerator, Gas Range
  • cooling: Electric
  • constructionmaterials: Stucco
  • flooring: Wood, Carpet
  • heating: Forced Air
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Garage, Off Street, Open
  • roof: Composition
  • waterfrontyn: False
  • franchiseaffiliation: RE/MAX International
  • interiorfeatures: Pantry, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
  • windowfeatures: Window Coverings
  • architecturalstyle: Contemporary
  • rooms: Basement, Bedroom 3, Game Room, Bathroom 2, Bathroom 1, Bathroom 4, Family Room, Bedroom 2, Den, Bathroom 5, Bathroom 3, Bedroom 1, Dining Room
  • securityfeatures: Security System
  • patioandporchfeatures: Deck, Patio
  • speciallistingconditions: Standard
  • basement: Full, Finished
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -94.64577, 39.015903
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-HMLSKS-2621550", "OpenHouseEndTime": "2026-05-30 15:00:00", "OpenHouseId": "4830463", "OpenHouseRemarks": "First open on this Story and a Half Lido Villa Home!!! Open 5/30/26 1-3", "OpenHouseStartTime": "2026-05-30 13:00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Remax Premier Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"dcostello@remax.net", "ListBrokerageCity":"Prairie Village", "ListBrokerageCountry":"US", "ListBrokerageEmail":"costello.admin@premierkchomes.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/HMLSKS/5512c1e1929211e3a8b622000ae18bf7/20140224194512760.png", "ListBrokerageName":"Remax Premier Realty", "ListBrokeragePhone":"(816) 591-3186", "ListBrokeragePostalCode":"66208", "ListBrokerageStateOrProvince":"KS", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"2210 W. 75th Street", "ListBrokerageWebsiteUrl":"http://www.costellorealestate.com", "ListOfficeAddress1":"2210 W 75th St ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"RMX_40", "ListOfficeCity":"Prairie Village", "ListOfficeCountry":"US", "ListOfficeEmail":"dcostello@remax.net", "ListOfficePostalCode":"66208", "ListOfficeStateOrProvince":"KS", "ListPriceCurrencyType":"USD", "ListingTitle":"CONDOS - Contemporary - Mission, KS", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/6243-Rosewood-Ct_Mission_KS_66205_M82513-54678?f=listhub&s=HMLSKS&m=2621550&c=rexren", "MLSModificationTimestamp":"2026-05-30 23:07:10", "Neighborhoods":[{"Description":null, "Name":"Lido Villas"}], "PostalCode":null, "RoomCount":14, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":5677, "TaxDescription":"LIDO VILLAS CERT OF SUR CONDOMINIUM PHASE II AS REC BK2161 P 608 UNIT 53 BLDG 10-B &AN UNDIVIDED INTEREST IN COMMON AREA & FAC MIC 276 6A 1H 10B 53", "TaxYear":null}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 5/31/2026 2:30:13 AM GMT
Source Updated Date: 6/4/2026 12:54:43 AM GMT

Courtesy of: David Costello, RE/MAX Premier Realty, dcostello@remax.net

Copyright © 2026 Heartland Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.