Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

3509 Rosewood, Columbia, IL, 62236

5beds
5baths
5,389sqft
$929,000
$172price/sqft
$6,809/moest. monthly cost
$272,360/yrincome needed

About This Home

This extraordinary executive estate offers luxury, thoughtful design, and extensive high-end upgrades throughout 5,300+ Sq. Ft. finished. With 25 rooms, 5 beds, and 5 baths resting on 1.36 acres, this stunning home is in one of Columbia’s most beautiful and convenient subdivisions—with no HOA—providing both privacy and convenience. Recent exterior improvements include a brand-new roof with copper flashings, along with some new windows, gutters, and downspouts, setting the tone for quality and craftsmanship from the moment you arrive. Inside, a grand two-story foyer showcases striking hand-cut black and white marble tile and a breathtaking split-landing staircase with a waterfall landing. New flooring with radiant heat flows throughout the main level. A private office with French doors sits just off the foyer, while the two-story living room impresses with arched transom windows, new flooring, and a classic wood-burning fireplace and walk out to pool deck area. The formal dining room is equally refined, featuring wide-plank flooring, fresh paint, and a decorative custom ceiling. The completely remodeled gourmet kitchen is nothing short of spectacular, anchored by an enormous center island with under-island cabinetry and designed to accommodate entertaining at scale. Highlights include Cambria countertops, a farmhouse sink, an additional vegetable sink with induction cooktop, two dishwashers, double ovens, tile pillars, updated designer lighting, and a custom butler’s pantry. A beverage station with beverage refrigerator is perfectly positioned between the kitchen and the primary living area for seamless hosting. The main level also boasts a large laundry room with ceramic flooring and deep sink, a half bath with marble flooring, and access to the oversized three-car garage featuring built-in cabinetry and a walk door. The primary suite on the main level is a true retreat, offering generous scale, a tray ceiling, and French doors opening directly to the pool deck. The expansive California-style custom walk-in closet is large enough to function as its own room. The luxurious ensuite bath includes a jetted soaking tub, walk-in shower, dual vanities, ceramic tile flooring, a private powder room, and an additional walk-in closet. Upstairs, a catwalk overlooks the foyer and connects via the dual-landing staircase. Bedroom #2 features a walk-in closet, and a shared Jack-and-Jill bath with bedroom #3. This bathroom offers separate vanity rooms, a tub/shower combo, ceramic tile, and a convenient laundry chute. Bedroom three boasts LVP flooring, a vaulted ceiling, new window, French doors, and a walk-in closet. Bedroom #4 serves as a second primary suite, complete with a walk-in closet and private ensuite bathroom with shower. The finished lower level significantly expands the living space with a large family room that includes pool table and dining areas, a custom bar with ice maker, beverage refrigerator, and glass shelving, a game and recreation room, and an oversized gym with rubber flooring and a stylish barn-door entry. A full bathroom with tile flooring and tub/shower combo and an additional bedroom with LVP flooring and open ceiling complete the lower level. Outdoor living rivals that of a private resort, featuring a saltwater swimming pool, a new oversized pool shed, pergola-covered patio, hot tub, and extended custom stone paver and rock areas—ideal for entertaining or relaxing in style. This remarkable executive home truly offers every bell and whistle, blending luxury, comfort, and thoughtful design into one unforgettable property.

Getting Around

0
WalkingCar-Dependent
0
TransitVery Limited Transit
18
BikeSomewhat Bikeable

Schools

--
8/10
Columbia Middle SchoolGrades 5-82.0 mi
8/10
Columbia High SchoolGrades 9-122.2 mi

Construction

Condition

  • Year built: 2004

Materials

  • Roof: Architectural Shingle
  • Construction materials: Brick

Type & Style

  • Home type: SingleFamily
  • Architectural style: Traditional,Other
  • Property subType: Single Family Residence

Interior

Appliances

  • Appliances included: Electric Water Heater,Dishwasher,Disposal,Double Oven,Electric Cooktop,Microwave,Refrigerator,Water Softener
  • Laundry features: Main Level

Basement

  • Has basement: Yes
  • Basement: Full,Partially Finished

Bathroom

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 30
  • Dimensions: 6x5

Bathroom

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 65
  • Dimensions: 13x5

Bathroom

  • Features: Floor Covering: Ceramic Tile
  • Level: Upper
  • Area: 45
  • Dimensions: 9x5

Bathroom

  • Features: Floor Covering: Ceramic Tile
  • Level: Lower
  • Area: 45
  • Dimensions: 9x5

Bedroom

  • Features: Floor Covering: Wood
  • Level: Main
  • Area: 168
  • Dimensions: 14x12

Bedroom

  • Features: Floor Covering: Wood
  • Level: Upper
  • Area: 210
  • Dimensions: 14x15

Bedroom

  • Features: Floor Covering: Wood
  • Level: Upper
  • Area: 165
  • Dimensions: 15x11

Bedrooms & Bathrooms

  • Bedrooms: 5
  • Bathrooms: 5
  • Full bathrooms: 4
  • 1/2 bathrooms: 1
  • Main level bathrooms: 2
  • Main level bedrooms: 1

Breakfast Room

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 130
  • Dimensions: 13x10

Dining Room

  • Features: Floor Covering: Other
  • Level: Main
  • Area: 238
  • Dimensions: 17x14

Exercise Room

  • Features: Floor Covering: Other
  • Level: Lower
  • Area: 666
  • Dimensions: 37x18

Features

  • Entrance Foyer,Breakfast Bar,Custom Cabinetry,Eat-in Kitchen,Pantry,Solid Surface Countertop(s),Double Vanity,Tub,Open Floorplan,Vaulted Ceiling(s),Walk-In Closet(s),Bar,Kitchen/Dining Room Combo
  • Door features: French Doors
  • Flooring: Hardwood
  • Number of fireplaces: 1
  • Fireplace features: Recreation Room,Living Room,Wood Burning
  • Fireplace: Yes
  • Finished area below ground: 1,800
  • Finished area above ground: 3,589

Heating & Cooling

  • Heating features: Electric,Forced Air,Geothermal,Radiant Floor,Zoned
  • Cooling features: Geothermal

Interior Area

  • Total structure area: 5,389
  • Total interior livable area: 5,389 sqft

Kitchen

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 169
  • Dimensions: 13x13

Laundry

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 55
  • Dimensions: 11x5

Living Room

  • Features: Floor Covering: Wood
  • Level: Main
  • Area: 462
  • Dimensions: 22x21

Office

  • Features: Floor Covering: Wood
  • Level: Main
  • Area: 169
  • Dimensions: 13x13

Office

  • Features: Floor Covering: Luxury Vinyl Plank
  • Level: Lower
  • Area: 225
  • Dimensions: 15x15

Other

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 210
  • Dimensions: 14x15

Other

  • Features: Floor Covering: Wood
  • Level: Lower
  • Area: 480
  • Dimensions: 24x20

Other

  • Features: Floor Covering: Concrete
  • Level: Lower
  • Area: 85
  • Dimensions: 17x5

Primary Bathroom

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 128
  • Dimensions: 16x8

Primary Bedroom

  • Features: Floor Covering: Wood
  • Level: Main
  • Area: 300
  • Dimensions: 20x15

Recreation Room

  • Features: Floor Covering: Wood
  • Level: Lower
  • Area: 851
  • Dimensions: 37x23

Storage

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 63
  • Dimensions: 9x7

Storage

  • Features: Floor Covering: Ceramic Tile
  • Level: Main
  • Area: 88
  • Dimensions: 8x11

Storage

  • Features: Floor Covering: Ceramic Tile
  • Level: Upper
  • Area: 48
  • Dimensions: 8x6

Storage

  • Features: Floor Covering: Ceramic Tile
  • Level: Upper
  • Area: 36
  • Dimensions: 12x3

Property

Details

  • Parcel number: 0427302005000
  • Special condition: Standard

Features

  • Levels: One and One Half
  • Private pool: Yes
  • Pool features: Private,In Ground
  • Patio & porch: Covered,Front Porch,Patio

Lot

  • Lot size: 1.36 Acres
  • Features: Level
  • Lot size dimensions: 1.36

Parking

  • Total spaces: 3
  • Parking features: Attached,Garage
  • Has garage: Yes
  • Attached garage spaces: 3
  • Covered spaces: 3