Sign In

Close

x
Showing 1 of 0
X
Save
23027 Stewart Avenue Warren MI 48089US4 Bed, 2.00 Bath (2 Full Bath), 1,072 square feet20261069954
23027 Stewart Avenue WarrenMI48089
159900.0000 1/1/1900 12:00:00 AM
Realty Executives Showcase Commercial
49433 Hayes RdShelby TownshipMI48315
586-726-4600
1 /

Courtesy of: Paul Gjelaj, Community Choice Realty Inc, paul@cmchoice.com

23027 Stewart Avenue
Warren MI 48089 US

Save
1 /

Courtesy of: Paul Gjelaj, Community Choice Realty Inc, paul@cmchoice.com

Realty Executives Showcase Commercial
49433 Hayes Rd
Shelby Township, MI, US 48315
586-726-4600

Get more info about this property

23027 Stewart Avenue
Warren MI 48089 US

$159,900

Active Listing ID 20261069954
bed icon
4 bed
rule icon
1,072 square feet
bath icon
2.00 Bath (2 Full)
lot icon
Lot: 0.17 Acres
home icon
Other

$159,900

Active Listing ID 20261069954
Save
3d icon
Maps

23027 Stewart Avenue Welcome to this stunning modern concept situated on a nice lot! This home is absolutely spectacular. Be taken back when entering your new home - featuring custom craftsmanship with premium wood trims, a newer kitchen and living spaces with award winning color choices, stella quartz countertops in kitchen and bath, with recessed lighting throughout, plus more. The stylish exterior boasts custom barn features with wood accents and custom landscaping. Newer appliance package! This property is nestled on a quiet street and makes for a quiet living with primarily homeowners on the street. Come on by so you can enjoy the backyard both morning and night, so bring your coffee and wine, and make this house your home - it won't last! Home is a certified rental by the City of Warren.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.17 Acres
  • Property Type: Residential
  • Property Sub-type: Other
  • Features
  • Full Bathrooms: 2
  • Cooling System: Central Air
  • Roof Type: Asphalt
  • Heating Fuels: Forced Air

Property

  • propertytype: Residential
  • propertysubtype: Other
  • listprice: 159900
  • unparsedaddress: 23027 Stewart Avenue
  • postalcity: Warren
  • stateorprovince: MI
  • country: US
  • postalcode: 48089
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.17
  • lotsizeunits: Acres
  • lotsizearea: 0.17
  • livingarea: 1072
  • livingareaunits: Square Feet
  • latitude: 42.464924
  • longitude: -82.972359
  • listagentfullname: Paul Gjelaj
  • listagentemail: paul@cmchoice.com
  • listagentkey: 3yd-REALCOMPMI-445333
  • listagentmlsid: 445333
  • listagentpreferredphone: 5866970510
  • listagentofficephone: 2487290011
  • listofficekey: 3yd-REALCOMPMI-338645
  • listofficemlsid: 338645
  • disclaimer: Copyright © 2026 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: REALCOMPMI
  • yearbuilt: 1938
  • listingcontractdate: 2026-09-06
  • listagenturl: http://www.cmchoice.com
  • countyorparish: Macomb
  • parcelnumber: 1325455052
  • elementaryschooldistrict: Eastpointe Community Schools
  • middleorjuniorschooldistrict: Eastpointe Community Schools
  • highschooldistrict: Eastpointe Community Schools
  • cooling: Central Air
  • constructionmaterials: Aluminum
  • heating: Forced Air
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 0
  • roof: Asphalt
  • waterfrontyn: False
  • franchiseaffiliation: None
  • architecturalstyle: Bungalow
  • rooms: Bedroom 3, Bathroom 2, Bedroom 2, Bathroom 1, Bedroom 1, Bedroom 4
  • speciallistingconditions: Standard
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -82.97236, 42.464924
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"COMMUNITY CHOICE REALTY INC.", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"paul@cmchoice.com", "ListBrokerageCity":"Birmingham", "ListBrokerageCountry":"US", "ListBrokerageEmail":"evans.jonathan@student.oaklandcc.edu", "ListBrokerageLogoUrl":null, "ListBrokerageName":"COMMUNITY CHOICE REALTY INC.", "ListBrokeragePhone":"(248) 729-0011", "ListBrokeragePostalCode":"48009", "ListBrokerageStateOrProvince":"MI", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"261 E. Maple", "ListBrokerageWebsiteUrl":"http://www.cmchoice.com", "ListOfficeAddress1":"261 E Maple ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"338645", "ListOfficeCity":"Birmingham", "ListOfficeCountry":"US", "ListOfficeEmail":"jon@cmchoice.com", "ListOfficePostalCode":"48009", "ListOfficeStateOrProvince":"MI", "ListPriceCurrencyType":"USD", "ListingTitle":"Residential, 1 1/2 Story, Warren, MI", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/23027-Stewart-Ave_Warren_MI_48089_M47075-38270?f=listhub&s=REALCOMPMI&m=20261069954&c=rexren", "MLSModificationTimestamp":"2026-09-08 19:14:21", "Neighborhoods":[{"Description":null, "Name":"Supervisors Chesterfield Park Sub 2"}], "PostalCode":null, "RoomCount":8, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":1955, "TaxDescription":"SUPERVISORS CHESTERFIELD PARK SUB NO 2 LOT129 INCL 1/2 VAC ALLEY L.17 P.38", "TaxYear":null}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 9/8/2026 11:33:19 PM GMT
Source Updated Date: 9/13/2026 12:45:22 AM GMT

Courtesy of: Paul Gjelaj, Community Choice Realty Inc, paul@cmchoice.com

Copyright © 2026 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact