Active
3 beds1,250 sqft$15/sqft
15175 Raphael Terrace, Warren, MI 48088
No pets allowedPet policy

Description

Must See SHARP NORTH WARREN TOWNHOUSE. Great Location close to everything. THREE Bedrooms, 1.5 Baths, & Full Private Basement. Nice kitchen cabinets. All appliances included. Just move in and enjoy. Great for everyone. One month and a half security deposit and one month rent are required to move in. Immediate Occupancy.Must See SHARP NORTH WARREN TOWNHOUSE. Great Location close to everything. THREE Bedrooms, 1.5 Baths, & Full Private Basement. Nice kitchen cabinets. All appliances included. Just move in and enjoy. Great for everyone. One month and a half security deposit and one month rent are required to move in. Immediate Occupancy.
9 days on Market
  • Listed by: Firas Manna 248.880.5935 firas.manna@outlook.com Brokerage DRE #6503367482 • National Realty Centers, Inc
Last updated: 09/09/2026 10:22 AM • Source: Realcomp, MLS#: 20261069843

Location

Listing Courtesy of National Realty Centers, Inc
Add your commute

Property Information for 15175 Raphael Terrace

Property Details
  • Lease Term: Lease Length: Months 12
  • Property Type: Townhouse
  • MLS Type: Residential Lease / Townhouse
  • Year Built: 1974
  • Subdivision Name: VENTURA
  • Architectural Style: Townhouse
  • Waterfront: No
  • Senior Community: No
Building Information
  • Building/Complex: 15175 Raphael Ter
  • Pet Policy: Not Allowed
  • Pet Policy Details: No
  • Year Built: 1974
Summary
Location and General Information
  • Directions: North 12 Mile Rd West Hayes Rd
  • Latitude: 42.51220629
  • Longitude: -82.971572
  • Cross Street: N of 12 Mile Rd / W of Hayes Rd
  • MLS Area Major: Warren (50023)
  • Direction Faces: West
Taxes and HOA
  • Parcel Number: 1312426120
  • Tax Legal Description: N 79 VENTURA CONDOMINIUM MACOMB COUNTY CONDOMINIUM SUBDIVISION PLAN NO. 112 BLDG M, APT 79 MASTER DEED L.2825, P.607 THRU 668
  • Association: No
School Information
  • High School District: Warren Woods
Parking
  • Attached Garage: No
  • Garage: No
  • Parking Features: No Garage
Property
Lot Information
  • Lot Size Units: Acres
  • Road Frontage Type: Paved
Property and Assessments
  • Living Area: 1250.0
  • Building Area Total: 1875.0
  • Above Grade Finished Area: 1250.0
  • Above Grade Finished Area Units: Square Feet
  • Below Grade Total Area: 625.0
  • Class Name: Residential Lease
  • Living Area Source: Public Records
  • New Construction: No
  • Year Built: 1974
Building Features
  • Construction Materials: Brick
  • Entry Location: Ground Level
  • Foundation Details: Basement, Poured
  • Levels: Two
  • Roof: Asphalt
  • Stories Total: 2
Utilities
  • Sewer: Public Sewer
  • Water Source: Public
Interior and Exterior Features
Interior Features
  • Bathrooms Total Notational: 1.1
  • Appliances: Dishwasher, Disposal, Dryer, Free Standing Electric Range, Free Standing Refrigerator, Microwave, Washer
  • Basement: Unfinished
  • Has Basement: Yes
  • Bathrooms Full: 1
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 2
  • Bedrooms Total: 3
  • Cooling: Central Air
  • Has Cooling: Yes
  • Fireplace: No
  • Heating: Forced Air, Natural Gas
  • Has Heating: Yes
  • Rooms Total: 6
  • Water Heater Fuel: Natural Gas
Exterior Features
  • Patio And Porch Features: Porch
Room Information
Room 1
  • Room Dimensions: 13 X 12
  • Room Length: 13.0
  • Room Width: 12.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Kitchen
Room 2
  • Room Description: Carpet
  • Room Dimensions: 11 X 9
  • Room Length: 11.0
  • Room Width: 9.0
  • Room Flooring: Carpet
  • Room Level: Second
  • Room Type: Bedroom 1
Room 3
  • Room Description: Carpet
  • Room Dimensions: 11 X 10
  • Room Length: 11.0
  • Room Width: 10.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Family Room
Room 4
  • Room Description: Ceramic
  • Room Dimensions: 9 X 16
  • Room Length: 9.0
  • Room Width: 16.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Bathroom 1
Room 5
  • Room Dimensions: 8 X 8
  • Room Length: 8.0
  • Room Width: 8.0
  • Room Flooring: Vinyl
  • Room Level: Entry
  • Room Type: Lavatory1
Room 6
  • Room Dimensions: 13 X 14
  • Room Length: 13.0
  • Room Width: 14.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Living Room
Room 7
  • Room Flooring: Ceramic Tile
  • Room Level: Second
  • Room Type: Primary Bathroom
Room 8
  • Room Flooring: Ceramic Tile
  • Room Level: Entry
  • Room Type: Bath Lav
Agent
Sale and Listings
  • Public GLR Website: Yes
Rental
Rent Information
  • Security Deposit: $2,400.00
  • Existing Lease: Yes
  • Lease Terms Available: Months12
  • Lease Type: Condominium
  • Pets Allowed: No
  • Rent Includes: Association Fee, Sewer, Snow Removal, Trash Collection, Water
  • Rent Spree: Yes

Property History for 15175 Raphael Terrace

DateEvent & SourcePriceAppreciation
Aug 31, 2026

Listed (Active)

Realcomp #20261069843

$1,600
Aug 31, 2026

Listed (Active)

MiRealSource #61026116

$1,600
Jun 30, 2026

Rented

MiRealSource #60999513

$1,625
DateEvent & SourcePrice
08/31/2026

Listed (Active)

Realcomp #20261069843

$1,600
08/31/2026

Listed (Active)

MiRealSource #61026116

$1,600
06/30/2026

Rented

MiRealSource #60999513

$1,625

For completeness, we often displays two records for one sale: the MLS record and the public record.

Schools near 15175 Raphael Terrace

This home is within Warren Woods Public Schools.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Public - K to 5
Rating
School
Distance
Pinewood Elementary School
PublicK to 5

Warren Woods Middle School
Public6 to 8

Warren Woods Tower High School
Public9 to 12

Briarwood Elementary School
PublicK to 5

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

15175 Raphael Terrace is available for rent in Warren, MI 48088. This property was listed on August 31, 2026 by National Realty Centers, Inc, it's currently listed at $1,600. It has been on the market for a total of 9 days and was last rented on June 30, 2026. This listing's school district is Warren Woods Public Schools. Nearby schools include Pinewood Elementary School, Warren Woods Middle School and Warren Woods Tower High School. 15175 Raphael Terrace is a 3-bed, 2-bath, 1,250 sqft a property built in 1974.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the owner's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of National Realty Centers, Inc

IDX provided courtesy of Realcomp II Ltd. via Compass and its related brokerages. Copyright 2026 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated on 09/09/2026 10:22 AM PST