Skip main navigation
Sold for $207,000 on 12/13/23
  • $207,000

    14871 Artesian St, Detroit, MI 48223

    3beds
    2,200sqft
    Single Family Residence
    Built in 1928
    6,098.4 Square Feet Lot
    $246,500 Zestimate®
    $94/sqft
    $1,657 Estimated rent

    Home value

    $246,500

    $222,000 - $271,000

    $1,657/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $1,657/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $1,657/mo

    Rent Zestimate®

    Refinance and save

    $1,371/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $1,371/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Nestled in the heart of historic Detroit, this enchanting 3-bedroom, 1.5-bath home exudes character and charm at every turn. Step inside, and you'll immediately be drawn to the cozy reading nooks found in each of the spacious bedrooms, creating the perfect spots for relaxation and contemplation. The living room boasts a natural fireplace, providing a warm and inviting ambiance, while the original hardwood floors add timeless elegance throughout the home. Pamper yourself in the full bath with its extra-large Cinderella tub, a sanctuary of relaxation. Convenience is key with the addition of a half bath for guests. Located in a vibrant neighborhood, this home offers the luxury of being within walking distance of a variety of restaurants, making dining out a breeze. The backyard features a delightful pergola, the perfect setting for outdoor gatherings or quiet moments of serenity. For all your storage needs, the attic provides extra space, ensuring you can keep your belongings neatly organized. This historic Detroit home is a captivating blend of the old and new, offering a unique opportunity to own a piece of the city's heritage. Whether you seek a cozy evening by the fireplace, a delightful outdoor oasis, or an appreciation for the home's rich history in its original hardwood floors, this property truly has it all. Don't miss out on the chance to make this remarkable house your new home. Schedule a viewing today!

    Zillow last checked: 8 hours ago

    Listing updated: August 06, 2025 at 07:00pm

    Listed by:

    Bethany Reyes 248-259-6583,

    KW Metro,

    Christopher King 248-707-0159,

    KW Metro

    Bought with:

    Nicole Gray, 6501414765

    Keller Williams Realty Lakeside

    Source: Realcomp II,MLS#: 20230085655MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 2
    • Full bathrooms: 1
    • 1/2 bathrooms: 1
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Ceiling Fans, Central Air
    Appliances
    • Included: Dishwasher, Disposal, Dryer, Free Standing Gas Oven, Free Standing Gas Range, Free Standing Refrigerator, Microwave, Washer
    Features
    • Basement: Partial,Partially Finished
    • Has fireplace: No
    Interior area
    • Total interior livable area: 2,200 sqft
    • Finished area above ground: 1,600
    • Finished area below ground: 600

    Property

    Parking
    • Total spaces: 1
    • Parking features: One Car Garage, Detached
    • Garage spaces: 1
    Features
    • Levels: Two
    • Stories: 2
    • Entry location: GroundLevelwSteps
    • Pool features: None
    Lot
    • Size: 6,098 sqft
    • Dimensions: 50 x 120
    Details
    • Parcel number: W27I190284S
    • Special conditions: Short Sale No,Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Cape Cod
    • Property subtype: Single Family Residence
    Materials
    • Brick
    • Foundation: Basement, Poured
    Condition
    • New construction: No
    • Year built: 1928

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public

    Community & neighborhood

    Location
    • Region: Detroit
    • Subdivision: ROSEDALE PARK SUB - NEZ

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $50 optional

    Other

    Other facts
    • Listing agreement: Exclusive Right To Sell
    • Listing terms: Cash,Conventional,FHA,Va Loan

    Price history

    DateEventPrice
    12/13/2023Sold$207,000+4%$94/sqft
    Source: Realcomp II #20230085655
    11/3/2023Listed for sale$199,000+110.6%$90/sqft
    Source: Realcomp II #20230085655
    8/17/2016Listing removed$94,500$43/sqft
    Source: CENTURY 21 Elegant Homes #215131044
    6/28/2016Pending sale$94,500$43/sqft
    Source: CENTURY 21 Elegant Homes #215131044
    3/31/2016Price change$94,500-4.5%$43/sqft
    Source: Century 21 Elegant Homes #215131044

    Public tax history

    YearProperty taxesTax assessment
    2024-- $1,200
    2023-- $1,200
    2022-- $1,200

    Find assessor info on the county website

    Neighborhood: Rosedale Park

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes

    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.

    Estimated market value

    $246,500

    Get a cash offer in 3 minutes

    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.

    Estimated market value

    $246,500