Register Now
Already registered? Login

Sign in to take advantage of all this site has to offer. Save your favorite listings and searches – also receive email updates when listings you like come on the market for free!
*Contact Information is NOT Shared*

Joe Joseph

Joe Joseph, GRI
Joseph Real Estate Inc.

40919 Auburndale Dr.
Sterling Heights, MI 48313
Contact Me 


Quick Search

view all



No Min.

No Max.
Back to Saved Search
Listing 19 out of 308
$275,000 For Sale

39738 Lembke
Sterling Heights, MI 48313

3 beds, 3 baths | Single Family Home
1,874 sq ft; lot: 10019 sq ft - MLS# 31359615
Property Photo


Current taxes NON-homestead. Beautiful custom Sterling Heights ranch featuring 3 bedrooms, 3 full bathrooms, & finished basement. Large lot with a fenced in back yard. Enter through the double door entry into the ceramic foyer & you will see the attention to detail with many custom features including wood trim & crown molding,vaulted beamed ceilings, raised hearth fireplace, and an open floor plan.The kitchen features oak cabinets with plenty of storage and an island. Newer SS refrigerator & stove. Kitchen is huge & open with door wall access to the private backyard featuring two patio areas, the main patio has a powered awning. Large laundry area with newer washer & dryer. Living rm ideal for gathering with raised vaulted ceilings & fireplace. Master bedroom features WIC & ensuite with floor to ceiling tiled shower. Basement is finished, features storage room with built-in shelving. Award winning UCS school district. Roof 2010, Furnace & A/C 11, Sump pump 12, Marygrove awning 12.


  • Property Type: Single Family Home
  • Sub Type: Residential
  • Listing Status: Active
  • County/Area: Macomb
  • Zip Code: 48313
  • Year Built: 1989
  • Subdivision/Neighborhood: Rivendell Sub
  • School District: Utica Community Schools
  • Sq.Ft.: 1,874 sq ft
  • Style: Ranch
  • Stories: 1 Story
  • Bedrooms: 3
  • Full Baths: 3
  • Basement: Block, Finished, Sump Pump, Yes
  • Garage: 2-Car, Attached Garage, Gar Door Opener, 2-Car
  • Fireplace: Natural Fireplace, Yes
  • Lot Size: 70 X 120
  • Baths: 3 baths
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Washer
  • Bath Descriptions: Mstrbdrm Full Bathroom, First Flr Full Bathroom
  • Bedroom 1 Size: 17 x 12
  • Bedroom 2 Level: First
  • Bedroom 2 Size: 12 x 11
  • Bedroom 3 Level: First
  • Bedroom 3 Size: 12 x 10
  • Below Grade Sqft: 1874
  • Cooling System: Central A/C
  • Dining/Kitchen: Eat-In Kitchen
  • Exterior Construction: Brick
  • Exterior Features: Fenced Yard, Lawn Sprinkler, Patio, Porch, Sidewalks
  • Foundation Type: Basement
  • Frontage: 70
  • Great Room Size: 23 x 17
  • Heat/Fuel Type: Natural Gas
  • Heating System: Forced Air
  • Interior Features: 9 Ft + Ceilings, Cable/Internet Avail., Cathedral/Vaulted Ceiling, Sump Pump, Walk-In Closet
  • Kitchen Level: First
  • Kitchen Size: 23 x 16
  • Laundry Room Size: 8 x 8
  • Municipality: Sterling Heights
  • Originating Mls: Mirealsource
  • Roads: Paved Street
  • Rooms: First Floor Bedroom, First Floor Laundry, First Floor Mstr Bedroom, Living Room, Utility/Laundry Room, Master Bedroom, Master Bathroom
  • Sale/Rent: For Sale
  • Sewer/Septic: Public Sanitary
  • Site Location: Subdivision, Walk To School
  • Source MLS: MiRealSource
  • Total Tax Amount: 5130
  • Water: Public Water
  • Water Heater: Gas
Courtesy of Keller Williams Realty Lakeside
Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu