ABSOLUTELY GORGEOUS NORTH FACING MODERN HOME FOR LEASE that boasts over 3200 sq ft of living space. This well maintained 4 bed, 2 full bath plus a half bath colonial located in the sought after VILLAS OF FONTANA neighborhood in Sterling Heights. This premium lot has plenty of privacy and a huge custom patio for endless summer entertainment. Inside the home features a large Great Room w/gas fireplace and a wall of windows. Formal Living and Dining Room plus aa stunning study perfect for todays work from home lifestyle. Kitchen features a large pantry, upgraded maple cabinets, granite counters, butlers pantry and hardwood floors in foyer and custom tile in Kitchen. The second floor has a huge MB room with cathedral ceiling, and master bath suite. Three additional bedrooms plus bathroom. Neutral paint-Spacious Basement and a 2 car garage all with in walking distance to Moravian Park. **NO SMOKING and NO PETS – **HOME IS OCCUPIED – LIMITED SHOWING TIMES AND ACCESS BY APPOINTMENT ONLY. **AVAILABLE FOR LEASE AFTER AUGUST 31, 2026** BATVAI ** RENTSPREE APPLICATION
Property Details
Price:
$3,250
MLS #:
20261054355
Status:
Active
Beds:
4
Baths:
3
Type:
Rental
Subtype:
SingleFamilyResidence
Subdivision:
VILLA FONTANA SUB #2
Neighborhood:
area03101sterlingheights
Listed Date:
Jul 20, 2026
Finished Sq Ft:
3,200
Year Built:
2002
See this Listing
Schools
School District:
WarrenCon
Interior
Above Grade Finished Area
3200
Appliances
BuiltInElectricOven, Dishwasher, Disposal, Dryer, FreeStandingRefrigerator, GasCooktop, Microwave, Washer
Bathrooms
2 Full Bathrooms, 1 Half Bathroom
Cooling
Ceiling Fans, Central Air
Heating
Forced Air, Natural Gas
Interior Features
EntranceFoyer, ProgrammableThermostat
Laundry Features
Laundry Room
Levels
Two
Exterior
Architectural Style
Colonial, Contemporary
Attached Garage YN
1
Construction Materials
Brick
Exterior Features
Chimney Caps, Lighting
Garage Spaces
2
Parking Features
TwoCarGarage, Attached
Patio And Porch Features
Patio, Porch
Roof
Asphalt
Security Features
Smoke Detectors
Financial
Map
Community
- Address14864 LIRI Drive Sterling Heights MI
- SubdivisionVILLA FONTANA SUB #2
- CitySterling Heights
- CountyMacomb
- Zip Code48312
Subdivisions in Sterling Heights
- A HENRY KOTNERS RYAN ROAD SUB # 17
- ABERDEEN GARDENS CONDO
- ABERDEEN PINES CONDO
- AMERICANA # 01
- AMERICANA # 02
- ANDOVER HEIGHTS
- ANNA LISA SUB
- ARLINGDALE HEIGHTS SUB
- BEAVER CREEK SUB
- BELMONT ESTATES
- BILTMORE PARK # 02
- BILTMORE PARK # 03
- BIRCHCREST SUB
- BRISTOL HEIGHTS #4
- BRISTOL HEIGHTS SUB
- BRISTOL HGHTS # 01
- BROOKSHIRE OFFICE PLAZA CONDO #1000
- CANDLEWOOD VILLAGE SUB 2
- CARRIER REAL CO CEN LANE ROAD
- CHELSEA GLEN
- CHERRY HILL FARMS
- CHERRY HILL FARMS SUB
- COACHWOOD SQUARE SUB
- CORNERSTONE CONDO
- COVENTRY ESTATES SUB
- COVENTRY SQUARE
- COVENTRY SQUARE SUB
- COVENTRY SQUARE SUB 2
- CRANBROOK CENTER CONDO
- CURTIS ACRES
- DE CLERCK SUB
- DENEAU SUB
- DEVONSHIRE SQUARE CONDO
- DOMINIC MOCERI SUB
- DOR-SAL ESTATES
- DRESDEN VILLAGE
- DRESDEN VILLAGE # 04
- DRESDEN VILLAGE SUB
- EAST HAMPTON
- EAST HAMPTON # 03
- EASTHAMPTON SUB
- EASTHAMPTON SUB 2
- EDGESTONE ESTATES
- ESSEX GARDENS
- ESSEX GARDENS SUB
- ESSEX NORTH
- ESSEX NORTH SUB
- EXECUTIVE HEIGHTS
- EXECUTIVE HEIGHTS SUB
- EYSTERS MOUND ROAD FARMS SUB #
- FAIRFIELD VILLAGE # 01
- FAIRFIELD VILLAGE SUB
- FAIRWAY GREEN
- FOREST CREEK SUB
- FOREST VIEW SUB 7
- FOX HILL ESTATES SUB
- FRANCESCA
- GARDEN FARMS
- GATEWAY OAKS CONDO #760
- GLENMERE ACRES
- GLENMERE ACRES SUB
- GOLFPOINTE VILLAGE
- GREENVIEW
- GREENVIEW SUB
- GRENAL # 01
- GULASON ESTATES
- HANNEBAUER PARC CONDOS
- HARWOOD
- HATHERLY
- HAVEN HEIGHTS SUB
- HEIN’S GARDENS
- HEINS GARDENS
- HERITAGE POINTE
- HICKORY HEIGHTS SUB
- HORIZON
- HORIZON # 02
- HORIZON SUB
- KINGSLEY
- KINGSLEY SUB
- KORESKY SUB
- LAKEPOINTE CONDOMINIUMS AT LAKESIDE
- LAKESHORE
- LAKESIDE SOUTH
- LAKESIDE WEST
- LEGACY HEIGHTS
- LENGTHY LEGAL DESCRIPTION METES & BOUNDS
- LINCOLN MANOR SUB
- LONDON HEIGHTS SUB 2
- LONG LEGAL
- MAPLE CREEK CONDO
- MAYWOOD EAST SUB
- MAYWOOD PARK SUBDIVISION
- MEADOWVIEW SUB
- METES & BOUNDS
- MIRACLE HOMES SUB
- MOCERI SPIZIZEN ESTATES SUB
- MONTEGO BAY SUB
- MONTICELLO ESTATES
- MONTICELLO ESTATES #3
- MORAVIAN MANOR CONDO
- MORAVIAN POINTE SUB
- MOUND GARDENS # 01
- MULBERRY ESTATES SUB
- NEW BRADFORD MANOR SUB
- NEW ERA VICTORY GARDEN FARMS
- NORTH POINTE CONDO
- NOTTINGHAM COVE CONDO #790
- PALM RYAN SITE CONDO
- PARK PLACE CONDO
- PARK PLACE WEST
- PARKSIDE POINTE CONDO
- PARKWAY ESTATES
- PENDLETON VILLAGE CONDO
- PINEBROOK NORTH SUB 1
- PINEBROOK SUB
- PINEWOOD COURT CONDO
- PLUM CREEK
- PLUMBROOK
- PLUMBROOK ESTATES SUB
- PLUMBROOK VILLAGE
- PLUMBROOK VILLAGE # 03
- PLUMBROOK VILLAGE CONDO
- PLUMBROOK VILLAGE SUB
- RESERVE CONDO
- RIDGECROFT NORTH SUB
- RIDGECROFT SOUTH SUB
- RIVENDELL SUB #2
- RIVER WOODS CONDO
- ROSENDALE SUB
- ROSENDALE SUB 1
- RUDGATE MANOR
- S/P # 04 STERLING HEIGHTS
- S/P CADY FARM
- S/P CARTWRIGHT FARMS
- S/P CURTIS ACRES
- S/P EYSTER’S MOUND RD FMS # 03
- S/P EYSTERS MOUND ROAD FARMS # 01
- S/P EYSTERS MOUND ROAD FARMS # 03
- S/P HEATHERLAND
- SEVILLE GARDENS
- SEVILLE TERRACE
- SEVILLE TERRACE CONDO
- SILVER MAPLE SUB
- SOMERSET MEADOWS SUB
- SOMERSET SQUARE
- SOUTH-HAMPTON SUB
- SPICEMILL SUB #4
- SPRING MEADOWS
- SPRING MEADOWS OF STERLING
- STERLING COMMONS
- STERLING COUNTRY ESTATES # 01
- STERLING COUNTRY ESTATES # 02
- STERLING COUNTRY ESTATES # 03
- STERLING COUNTRY ESTATES SUB
- STERLING CREEK CONDO #929
- STERLING HUNT CLUB CONDO
- STERLING KNOLLS SUB
- STERLING MANOR SUB
- STERLING SQUARE
- STERLING WOODS CONDO #668
- STONEGATE MANOR
- STRATFORD VILLAGE NORTH CONDO #754
- STRATFORD VILLAGE REGENTS #690
- STRATFORD VILLAGE TERRACES #674
- SUNCREST SUB
- SUPERVISORS CLINTON VALLEY SUB
- SURREY ESTATES SUB
- SUSSEX MANOR SUB
- TAKOMA PARK SUB
- TARRYTON # 02
- TARRYTON SUB 2
- TARRYTON SUBDIVISION #02
- TERRA SANTA VILLAGE SUB
- THE ARBORS
- THE TOWNS AT ORCHARD SQUARE #696
- TROY MEADOWS #632
- TYMBER RIDGE SUB
- UNIVERSITY ESTATES SUB
- UNIVERSITY ESTATES SUB 3
- VILLA FONTANA SUB
- VILLAGE AT VINEYARDS
- VINEYARDS SUB #5
- VINEYARDS SUB #8
- VINEYARDS SUBDIVISION
- WALDEN ESTATES
- WESTBRIDGE MANOR
- WESTCHESTER SUB
- WILLOW WOODS
- WILSHIRE SUB
- WINTHROP # 01
- WINTHROP SUB
- WINTHROP SUB 2
Market Summary
Current real estate data for Rental in Sterling Heights as of Jul 30, 2026
62
Rental Listed
88
Avg DOM
1
Avg $ / SqFt
$2,124
Avg List Price
Property Summary
- Located in the VILLA FONTANA SUB #2 subdivision, 14864 LIRI Drive Sterling Heights MI is a Rental for sale in Sterling Heights, MI, 48312. It is listed for $3,250 To schedule a showing of MLS#20261054355 at 14864 LIRI Drive in Sterling Heights, MI, contact your LoChirco Realty, LLC agent at 586-321-9997.
Similar Listings Nearby
14864 LIRI Drive
Sterling Heights, MI