SELECT property.* , address.street, address.city, address.county, address.state, address.zip, management.*, images.imgname, units.rent FROM property LEFT OUTER JOIN address ON property.property_id = address.property_id LEFT OUTER JOIN management ON property.property_id = management.property_id LEFT OUTER JOIN images ON property.property_id = images.property_id LEFT OUTER JOIN units ON property.property_id = units.property_id WHERE status = '1' AND featured = '1' AND state = 'WI' AND (units.pos = '1' OR units.pos IS NULL) AND (images.pos='1' OR images.pos IS NULL)

SELECT * FROM property LEFT OUTER JOIN (SELECT *,CONCAT(city,state) as citystate FROM address) a ON property.property_id = a.property_id LEFT OUTER JOIN management ON property.property_id = management.property_id LEFT OUTER JOIN amunit ON property.property_id = amunit.property_id LEFT OUTER JOIN ambldng ON property.property_id = ambldng.property_id LEFT OUTER JOIN amcomm ON property.property_id = amcomm.property_id LEFT OUTER JOIN (SELECT * FROM images WHERE pos='1' OR pos IS NULL) images ON property.property_id = images.property_id LEFT OUTER JOIN pets ON property.property_id = pets.property_id WHERE status='1' AND featured='1' AND state='WI' AND state!='WI'

 Apartments for Rent | Apartments in WI

Home

View My Favorites

Owners & Managers

Blog

Contact Us
Apartment Living Guide
Property Name
Property Type
Price
Bedrooms
Amenities
Pets


Apartments in , WI



Featured Properties

Close Match

Prairie Oaks
Prairie Oaks
866-310-6612
Verona, WI
1 BR    2 BR     $727 - $1049

Check Availability Add to Favorites
Whitcomb Corner
Whitcomb Corner
877-543-0334
Madison, WI
2 BR    3 BR+ $945 - $1065

Check Availability Add to Favorites
Cedar Glen
Cedar Glen
888-558-4109
Cross Plains, WI
ST    1 BR    2 BR     $595 - $895

Check Availability Add to Favorites
Lisbon Court
Lisbon Court
414-939-8491
Milwaukee, WI
1 BR    2 BR    3 BR+ $680 - $935

Check Availability Add to Favorites
3D Floorplans Available! Country Meadows
Country Meadows
888-905-7172
Madison, WI
ST    1 BR    2 BR     $535 - $805

Check Availability Add to Favorites
LeSilve
LeSilve
888-464-5949
Middleton, WI
ST    1 BR    2 BR     $765 - $1400

Check Availability Add to Favorites
The Constellation
The Constellation
888-851-2744
Madison, WI
ST    1 BR    2 BR    3 BR+ $895 - $2165

Check Availability Add to Favorites
Bridlewood Apartment Homes
Bridlewood Apartment Homes
866-841-1521
Pewaukee, WI
1 BR    2 BR     $915 - $1171

Check Availability Add to Favorites
1609 North Prospect
1609 North Prospect
888-842-8212
Milwaukee, WI
1 BR    2 BR     $835 - $1285

Check Availability Add to Favorites
Autumnwood
Autumnwood
608-467-4794
Madison, WI
ST    1 BR    2 BR     $679 - $999

Check Availability Add to Favorites
NorthPointe Apartments
NorthPointe Apartments
888-595-0272
Milwaukee, WI
1 BR    2 BR    3 BR+ $925 - $1695

Check Availability Add to Favorites
Parkside Apartments
Parkside Apartments
877-500-6957
Madison, WI
1 BR    2 BR     $730 - $990

Check Availability Add to Favorites
Prairie Oaks
Prairie Oaks
866-310-6612
Verona, WI
1 BR    2 BR     $727 - $1049

Check Availability Add to Favorites
Whitcomb Corner
Whitcomb Corner
877-543-0334
Madison, WI
2 BR    3 BR+ $945 - $1065

Check Availability Add to Favorites
Cedar Glen
Cedar Glen
888-558-4109
Cross Plains, WI
ST    1 BR    2 BR     $595 - $895

Check Availability Add to Favorites
Lisbon Court
Lisbon Court
414-939-8491
Milwaukee, WI
1 BR    2 BR    3 BR+ $680 - $935

Check Availability Add to Favorites
3D Floorplans Available! Country Meadows
Country Meadows
888-905-7172
Madison, WI
ST    1 BR    2 BR     $535 - $805

Check Availability Add to Favorites
LeSilve
LeSilve
888-464-5949
Middleton, WI
ST    1 BR    2 BR     $765 - $1400

Check Availability Add to Favorites
The Constellation
The Constellation
888-851-2744
Madison, WI
ST    1 BR    2 BR    3 BR+ $895 - $2165

Check Availability Add to Favorites
Bridlewood Apartment Homes
Bridlewood Apartment Homes
866-841-1521
Pewaukee, WI
1 BR    2 BR     $915 - $1171

Check Availability Add to Favorites
1609 North Prospect
1609 North Prospect
888-842-8212
Milwaukee, WI
1 BR    2 BR     $835 - $1285

Check Availability Add to Favorites
Autumnwood
Autumnwood
608-467-4794
Madison, WI
ST    1 BR    2 BR     $679 - $999

Check Availability Add to Favorites
NorthPointe Apartments
NorthPointe Apartments
888-595-0272
Milwaukee, WI
1 BR    2 BR    3 BR+ $925 - $1695

Check Availability Add to Favorites
Parkside Apartments
Parkside Apartments
877-500-6957
Madison, WI
1 BR    2 BR     $730 - $990

Check Availability Add to Favorites
51af3c1499b1751af3ccf6f65951af3c6acb8c7
Stratford Village Townhomes
Stratford Village Townhomes
8273 North Teutonia Avenue
Brown Deer, WI 53209
2 Bedrooms $895-$995
888-466-1906
Check Availability
Add to Favorites


Fischer Heights
Fischer Heights
12815-19 West Hampton
Butler, WI 53007
2 Bedrooms $895
888-765-1727
Check Availability
Add to Favorites


Maplewood
Maplewood
3017 6 Mile Road
Caledonia, WI 53402
2 Bedrooms $825-$875
888-443-9642
Check Availability
Add to Favorites


Prairie Grove
Prairie Grove
700-750 Sandpiper Trail
Cottage Grove, WI 53527
Studio $760 1 Bedroom $905-$1195 2 Bedrooms $1110
888-719-2934
Check Availability
Add to Favorites


Cedar Glen
Cedar Glen
1833 Ludden Drive
Cross Plains, WI 53528
Studio $595-$630 1 Bedroom $700-$770 2 Bedrooms $875-$895
888-558-4109
Check Availability
Add to Favorites


Highland Fields
Highland Fields
805 Tanglewood Drive
DeForest, WI 53532
Studio $700 1 Bedroom $855-$1125 2 Bedrooms $1095
888-719-2934
Check Availability
Add to Favorites


New Fountains
New Fountains
5401 Williamsburg Way
Fitchburg, WI 53719
Studio $665-$675 1 Bedroom $765-$810 2 Bedrooms $915-$1000
888-376-9780
Check Availability
Add to Favorites


Seminole Creek
Seminole Creek
2808 Mickelson Parkway
Fitchburg, WI 53711
1 Bedroom $839-$999 2 Bedrooms $1089-$1149
608-340-1101
Check Availability
Add to Favorites


Highland Ridge Of Seminole
Highland Ridge Of Seminole
2976 Chapel Valley
Fitchburg, WI 53711
Studio $765 1 Bedroom $940-$1160 2 Bedrooms $1175
888-744-8780
Check Availability
Add to Favorites


Franklin Meadows
Franklin Meadows
7704 South 51st Street
Franklin, WI 53132
1 Bedroom $50-$650
888-448-3995
Check Availability
Add to Favorites


Prairie Meadows II & III Senior Apartments
Prairie Meadows II & III Senior Apartments
W168 N11374 Western Avenue
Germantown, WI 53022
1 Bedroom $771 2 Bedrooms $905-$917
888-470-4103
Check Availability
Add to Favorites


Clayton Park Townhomes
Clayton Park Townhomes
5400-46 North Iroquois
Glendale, WI 53217
2 Bedrooms $1200
877-866-2389
Check Availability
Add to Favorites


River's Edge
River's Edge
100 West Walnut Street
Green Bay, WI 54303
1 Bedroom $615 2 Bedrooms $720-$805
920-437-7368
Check Availability
Add to Favorites


Ontario Road Apartments
Ontario Road Apartments
1501 Ontario Road
Green Bay, WI 54311
2 Bedrooms $735
888-876-6001
Check Availability
Add to Favorites


Crystal Lake
Crystal Lake
1530 Crystal Lake Circle
Green Bay, WI 54311
1 Bedroom $635-$819 2 Bedrooms $700-$1400 3 Bedrooms+ $1400-$1450
888-721-7353
Check Availability
Add to Favorites


Loomis Hills
Loomis Hills
4057 South 35th Street
Greenfield, WI 53221
1 Bedroom $580-$675
414-973-8381
Check Availability
Add to Favorites


Heritage Lake
Heritage Lake
5020 South 55th Street
Greenfield, WI 53220
1 Bedroom $845 2 Bedrooms $870-$950
888-865-9340
Check Availability
Add to Favorites


Heritage Village
Heritage Village
5055 South 55th Street
Greenfield, WI 53220
1 Bedroom $765-$910 2 Bedrooms $825-$1000
888-687-9143
Check Availability
Add to Favorites


Honeysuckle Apartments
Honeysuckle Apartments
1561-1565 Honeysuckle Road
Hartford, WI 53027
1 Bedroom $565 2 Bedrooms $665
877-892-9610
Check Availability
Add to Favorites


Stationside Village
Stationside Village
5215 11th Avenue
Kenosha, WI 53140
2 Bedrooms $710-$965
888-330-4515
Check Availability
Add to Favorites


Close Match


Stratford Village Townhomes
Stratford Village Townhomes
8273 North Teutonia Avenue
Brown Deer, WI 53209
888-466-1906
2 Bedrooms $895-$995
Check Availability
Add to Favorites


Fischer Heights
Fischer Heights
12815-19 West Hampton
Butler, WI 53007
888-765-1727
2 Bedrooms $895
Check Availability
Add to Favorites


Maplewood
Maplewood
3017 6 Mile Road
Caledonia, WI 53402
888-443-9642
2 Bedrooms $825-$875
Check Availability
Add to Favorites


Prairie Grove
Prairie Grove
700-750 Sandpiper Trail
Cottage Grove, WI 53527
888-719-2934
Studio $760 1 Bedroom $905-$1195 2 Bedrooms $1110
Check Availability
Add to Favorites


Cedar Glen
Cedar Glen
1833 Ludden Drive
Cross Plains, WI 53528
888-558-4109
Studio $595-$630 1 Bedroom $700-$770 2 Bedrooms $875-$895
Check Availability
Add to Favorites


Highland Fields
Highland Fields
805 Tanglewood Drive
DeForest, WI 53532
888-719-2934
Studio $700 1 Bedroom $855-$1125 2 Bedrooms $1095
Check Availability
Add to Favorites


New Fountains
New Fountains
5401 Williamsburg Way
Fitchburg, WI 53719
888-376-9780
Studio $665-$675 1 Bedroom $765-$810 2 Bedrooms $915-$1000
Check Availability
Add to Favorites


Seminole Creek
Seminole Creek
2808 Mickelson Parkway
Fitchburg, WI 53711
608-340-1101
1 Bedroom $839-$999 2 Bedrooms $1089-$1149
Check Availability
Add to Favorites


Highland Ridge Of Seminole
Highland Ridge Of Seminole
2976 Chapel Valley
Fitchburg, WI 53711
888-744-8780
Studio $765 1 Bedroom $940-$1160 2 Bedrooms $1175
Check Availability
Add to Favorites


Franklin Meadows
Franklin Meadows
7704 South 51st Street
Franklin, WI 53132
888-448-3995
1 Bedroom $50-$650
Check Availability
Add to Favorites


Prairie Meadows II & III Senior Apartments
Prairie Meadows II & III Senior Apartments
W168 N11374 Western Avenue
Germantown, WI 53022
888-470-4103
1 Bedroom $771 2 Bedrooms $905-$917
Check Availability
Add to Favorites


Clayton Park Townhomes
Clayton Park Townhomes
5400-46 North Iroquois
Glendale, WI 53217
877-866-2389
2 Bedrooms $1200
Check Availability
Add to Favorites


River's Edge
River's Edge
100 West Walnut Street
Green Bay, WI 54303
920-437-7368
1 Bedroom $615 2 Bedrooms $720-$805
Check Availability
Add to Favorites


Ontario Road Apartments
Ontario Road Apartments
1501 Ontario Road
Green Bay, WI 54311
888-876-6001
2 Bedrooms $735
Check Availability
Add to Favorites


Crystal Lake
Crystal Lake
1530 Crystal Lake Circle
Green Bay, WI 54311
888-721-7353
1 Bedroom $635-$819 2 Bedrooms $700-$1400 3 Bedrooms+ $1400-$1450
Check Availability
Add to Favorites


Loomis Hills
Loomis Hills
4057 South 35th Street
Greenfield, WI 53221
414-973-8381
1 Bedroom $580-$675
Check Availability
Add to Favorites


Heritage Lake
Heritage Lake
5020 South 55th Street
Greenfield, WI 53220
888-865-9340
1 Bedroom $845 2 Bedrooms $870-$950
Check Availability
Add to Favorites


Heritage Village
Heritage Village
5055 South 55th Street
Greenfield, WI 53220
888-687-9143
1 Bedroom $765-$910 2 Bedrooms $825-$1000
Check Availability
Add to Favorites


Honeysuckle Apartments
Honeysuckle Apartments
1561-1565 Honeysuckle Road
Hartford, WI 53027
877-892-9610
1 Bedroom $565 2 Bedrooms $665
Check Availability
Add to Favorites


Stationside Village
Stationside Village
5215 11th Avenue
Kenosha, WI 53140
888-330-4515
2 Bedrooms $710-$965
Check Availability
Add to Favorites


Apartment Living Guide

Google+ Pin It

Apartment Living Guide allows you to search for a new home through our approachable and easy to use platform. Our goal is to help ease the stress of moving by streamlining the path to your ideal apartment. Browse apartments for rent by location and must-have amenities. Also, feel free to customize your search and interact with our 3-D floor plans and walk score maps.

We are excited to announce the launch of our newly redesigned website! To provide an optimal experience for our users, we have incorporated responsive web design to ensure our site is easy for you to use on all devices. Apartment Living Guide brings you the ideal solution for finding your next apartment without bombarding you with unrelated advertising.


For Advertising Information


Scott Holgate
Office: 952.460.1916
Cell: 763.219.6621
Email: Scott@AptLivingGuide.com

Burt Bauman
Office: 952.460-1925
Cell: 612.940.9133
Email: Burt@AptLivingGuide.com


Apartment Living Guide & AptLivingGuide.com are companies of:


Planet Media Communications, LLC
14216 23rd Avenue North Plymouth, MN 55447
Phone: 952.460.1930
Fax: 763.951.2593


Terms and Conditions


View Terms and Conditions Here

Home  |  Login  |  Popular Cities  |  States
© 2011-2013 Apartment Living Guide All Rights Reserved