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 = 'MN' 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='MN' AND state!='MN'

 Apartments for Rent | Apartments in MN

Home

View My Favorites

Owners & Managers

Blog

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


Apartments in , MN



Featured Properties

Close Match

Pointe West
Pointe West
888-741-8044
Saint Cloud, MN
1 BR    2 BR    3 BR+ $595 - $929

Check Availability Add to Favorites
3D Floorplans Available! Atrium
Atrium
877-488-5743
Burnsville, MN
1 BR    2 BR     $700 - $1470

Check Availability Add to Favorites
Gatewood Apartments
Gatewood Apartments
888-848-7133
Waite Park, MN
1 BR    2 BR    3 BR+ $510 - $825

Check Availability Add to Favorites
Elan Uptown
Elan Uptown
888-510-0747
Minneapolis, MN
ST    1 BR    2 BR     $1330 - $3060

Check Availability Add to Favorites
Timberland Point
Timberland Point
888-827-8036
Saint Cloud, MN
1 BR    2 BR     $545 - $675

Check Availability Add to Favorites
BlueStone Lofts
BlueStone Lofts
888-694-4944
Duluth, MN
ST    1 BR    2 BR    3 BR+ $565 - $1490

Check Availability Add to Favorites
Olympik Village Apartments
Olympik Village Apartments
888-460-6255
Rochester, MN
1 BR    2 BR    3 BR+ $650 - $881

Check Availability Add to Favorites
3D Floorplans Available! Lexington Heights
Lexington Heights
888-573-8323
Mendota Heights, MN
1 BR    2 BR     $905 - $1085

Check Availability Add to Favorites
Timberland Crossing
Timberland Crossing
888-827-8036
Saint Cloud, MN
1 BR    2 BR     $545 - $675

Check Availability Add to Favorites
3D Floorplans Available! Lancaster Place
Lancaster Place
888-821-3908
Saint Cloud, MN
1 BR    2 BR    3 BR+ $580 - $770

Check Availability Add to Favorites
Summit Ridge Luxury Apartments
Summit Ridge Luxury Apartments
888-431-3255
Duluth, MN
1 BR    2 BR    3 BR+ $800 - $1605

Check Availability Add to Favorites
Willow Greens
Willow Greens
763-219-6621
Edina, MN
2 BR    3 BR+ $1425 - $1925

Check Availability Add to Favorites
Pointe West
Pointe West
888-741-8044
Saint Cloud, MN
1 BR    2 BR    3 BR+ $595 - $929

Check Availability Add to Favorites
3D Floorplans Available! Atrium
Atrium
877-488-5743
Burnsville, MN
1 BR    2 BR     $700 - $1470

Check Availability Add to Favorites
Gatewood Apartments
Gatewood Apartments
888-848-7133
Waite Park, MN
1 BR    2 BR    3 BR+ $510 - $825

Check Availability Add to Favorites
Elan Uptown
Elan Uptown
888-510-0747
Minneapolis, MN
ST    1 BR    2 BR     $1330 - $3060

Check Availability Add to Favorites
Timberland Point
Timberland Point
888-827-8036
Saint Cloud, MN
1 BR    2 BR     $545 - $675

Check Availability Add to Favorites
BlueStone Lofts
BlueStone Lofts
888-694-4944
Duluth, MN
ST    1 BR    2 BR    3 BR+ $565 - $1490

Check Availability Add to Favorites
Olympik Village Apartments
Olympik Village Apartments
888-460-6255
Rochester, MN
1 BR    2 BR    3 BR+ $650 - $881

Check Availability Add to Favorites
3D Floorplans Available! Lexington Heights
Lexington Heights
888-573-8323
Mendota Heights, MN
1 BR    2 BR     $905 - $1085

Check Availability Add to Favorites
Timberland Crossing
Timberland Crossing
888-827-8036
Saint Cloud, MN
1 BR    2 BR     $545 - $675

Check Availability Add to Favorites
3D Floorplans Available! Lancaster Place
Lancaster Place
888-821-3908
Saint Cloud, MN
1 BR    2 BR    3 BR+ $580 - $770

Check Availability Add to Favorites
Summit Ridge Luxury Apartments
Summit Ridge Luxury Apartments
888-431-3255
Duluth, MN
1 BR    2 BR    3 BR+ $800 - $1605

Check Availability Add to Favorites
Willow Greens
Willow Greens
763-219-6621
Edina, MN
2 BR    3 BR+ $1425 - $1925

Check Availability Add to Favorites
51af3fb77759d51af3ee24da4751af3f66cc27e
Park South Apartments
Park South Apartments
1813 & 1815 Aga Drive
Alexandria, MN 56308
2 Bedrooms $600
320-815-7200
Check Availability
Add to Favorites


Cutters Grove Apartment Homes
Cutters Grove Apartment Homes
2901 Cutters Grove Ave.
Anoka, MN 55303
1 Bedroom $865-$1099 2 Bedrooms $1045-$1255 3 Bedrooms+ $1350-$1450
888-429-2149
Check Availability
Add to Favorites


Valley Pond
Valley Pond
5520 W 142nd St #311
Apple Valley, MN 55124
1 Bedroom $840-$870 2 Bedrooms $970-$1029 3 Bedrooms+ $1160-$1180
888-348-2135
Check Availability
Add to Favorites


Cedar Pond
Cedar Pond
7455 123rd St W
Apple Valley, MN 55124
Studio $570 1 Bedroom $650
888-702-2898
Check Availability
Add to Favorites


Fair Oaks Apartments
Fair Oaks Apartments
200, 202, 204 - 11th Street NW
Austin, MN 55912
2 Bedrooms $600-$700
888-219-5208
Check Availability
Add to Favorites


North Bay At The Lakes
North Bay At The Lakes
3195 124th Avenue NE
Blaine, MN 55449
1 Bedroom $1175 2 Bedrooms $1325-$1500 3 Bedrooms+ $1625
877-414-7157
Check Availability
Add to Favorites


Tealwood
Tealwood
9900 Briar Road
Bloomington, MN 55437
1 Bedroom $889-$1059 2 Bedrooms $1273
888-518-1446
Check Availability
Add to Favorites


Hampshire Hill
Hampshire Hill
10660 Hampshire Avenue South
Bloomington, MN 55438
Studio $804-$903 1 Bedroom $777-$1084 2 Bedrooms $961-$1240
888-434-2857
Check Availability
Add to Favorites


Pebblebrook Flats
Pebblebrook Flats
9801 W Harrison Road
Bloomington, MN 55437
Studio $740-$820 1 Bedroom $815-$970 2 Bedrooms $980-$1220 3 Bedrooms+ $1190-$1220
888-461-3591
Check Availability
Add to Favorites


Pebblebrook Court
Pebblebrook Court
9801 W Harrison Road
Bloomington, MN 55437
Studio $740-$820 1 Bedroom $815-$970 2 Bedrooms $980-$1220 3 Bedrooms+ $1190-$1220
888-690-4218
Check Availability
Add to Favorites


Morgan Apartments
Morgan Apartments
10000-10024 Morgan Ave S
Bloomington, MN 55431
1 Bedroom $675 2 Bedrooms $775
888-702-2898
Check Availability
Add to Favorites


Chateau De France
Chateau De France
10717 France Ave S
Bloomington, MN 55431
Studio $600 2 Bedrooms $920
888-702-2898
Check Availability
Add to Favorites


1819 W Old Shakopee
1819 W Old Shakopee
1819 W Old Shakopee
Bloomington, MN 55431
2 Bedrooms $850
888-702-2898
Check Availability
Add to Favorites


8420 Fremont Ave S
8420 Fremont Ave S
8420 Fremont Ave S
Bloomington, MN 55420
1 Bedroom $650
888-702-2898
Check Availability
Add to Favorites


Cedar Court West
Cedar Court West
8910 18th Ave S
Bloomington, MN 55425
1 Bedroom $695 2 Bedrooms $875
888-702-2898
Check Availability
Add to Favorites


Cedar Court
Cedar Court
9005 Old Cedar Ave
Bloomington, MN 55425
1 Bedroom $695 2 Bedrooms $825
888-702-2898
Check Availability
Add to Favorites


Willow Court
Willow Court
4141 W Old Shakopee
Bloomington, MN 55437
Studio $610 1 Bedroom $710 2 Bedrooms $835
888-702-2898
Check Availability
Add to Favorites


Lyn Villa
Lyn Villa
10101 Lyndale Ave S
Bloomington, MN 55420
1 Bedroom $695 2 Bedrooms $875 3 Bedrooms+ $995
888-702-2898
Check Availability
Add to Favorites


Colonial Estates Townhomes
Colonial Estates Townhomes
8500 22nd Ave
Bloomington, MN 55425
3 Bedrooms+ $1025
888-702-2898
Check Availability
Add to Favorites


Cedar Cliff
Cedar Cliff
9300 Old Cedar Ave S
Bloomington, MN 55431
1 Bedroom $775 2 Bedrooms $915
888-702-2898
Check Availability
Add to Favorites


Close Match


Park South Apartments
Park South Apartments
1813 & 1815 Aga Drive
Alexandria, MN 56308
320-815-7200
2 Bedrooms $600
Check Availability
Add to Favorites


Cutters Grove Apartment Homes
Cutters Grove Apartment Homes
2901 Cutters Grove Ave.
Anoka, MN 55303
888-429-2149
1 Bedroom $865-$1099 2 Bedrooms $1045-$1255 3 Bedrooms+ $1350-$1450
Check Availability
Add to Favorites


Valley Pond
Valley Pond
5520 W 142nd St #311
Apple Valley, MN 55124
888-348-2135
1 Bedroom $840-$870 2 Bedrooms $970-$1029 3 Bedrooms+ $1160-$1180
Check Availability
Add to Favorites


Cedar Pond
Cedar Pond
7455 123rd St W
Apple Valley, MN 55124
888-702-2898
Studio $570 1 Bedroom $650
Check Availability
Add to Favorites


Fair Oaks Apartments
Fair Oaks Apartments
200, 202, 204 - 11th Street NW
Austin, MN 55912
888-219-5208
2 Bedrooms $600-$700
Check Availability
Add to Favorites


North Bay At The Lakes
North Bay At The Lakes
3195 124th Avenue NE
Blaine, MN 55449
877-414-7157
1 Bedroom $1175 2 Bedrooms $1325-$1500 3 Bedrooms+ $1625
Check Availability
Add to Favorites


Tealwood
Tealwood
9900 Briar Road
Bloomington, MN 55437
888-518-1446
1 Bedroom $889-$1059 2 Bedrooms $1273
Check Availability
Add to Favorites


Hampshire Hill
Hampshire Hill
10660 Hampshire Avenue South
Bloomington, MN 55438
888-434-2857
Studio $804-$903 1 Bedroom $777-$1084 2 Bedrooms $961-$1240
Check Availability
Add to Favorites


Pebblebrook Flats
Pebblebrook Flats
9801 W Harrison Road
Bloomington, MN 55437
888-461-3591
Studio $740-$820 1 Bedroom $815-$970 2 Bedrooms $980-$1220 3 Bedrooms+ $1190-$1220
Check Availability
Add to Favorites


Pebblebrook Court
Pebblebrook Court
9801 W Harrison Road
Bloomington, MN 55437
888-690-4218
Studio $740-$820 1 Bedroom $815-$970 2 Bedrooms $980-$1220 3 Bedrooms+ $1190-$1220
Check Availability
Add to Favorites


Morgan Apartments
Morgan Apartments
10000-10024 Morgan Ave S
Bloomington, MN 55431
888-702-2898
1 Bedroom $675 2 Bedrooms $775
Check Availability
Add to Favorites


Chateau De France
Chateau De France
10717 France Ave S
Bloomington, MN 55431
888-702-2898
Studio $600 2 Bedrooms $920
Check Availability
Add to Favorites


1819 W Old Shakopee
1819 W Old Shakopee
1819 W Old Shakopee
Bloomington, MN 55431
888-702-2898
2 Bedrooms $850
Check Availability
Add to Favorites


8420 Fremont Ave S
8420 Fremont Ave S
8420 Fremont Ave S
Bloomington, MN 55420
888-702-2898
1 Bedroom $650
Check Availability
Add to Favorites


Cedar Court West
Cedar Court West
8910 18th Ave S
Bloomington, MN 55425
888-702-2898
1 Bedroom $695 2 Bedrooms $875
Check Availability
Add to Favorites


Cedar Court
Cedar Court
9005 Old Cedar Ave
Bloomington, MN 55425
888-702-2898
1 Bedroom $695 2 Bedrooms $825
Check Availability
Add to Favorites


Willow Court
Willow Court
4141 W Old Shakopee
Bloomington, MN 55437
888-702-2898
Studio $610 1 Bedroom $710 2 Bedrooms $835
Check Availability
Add to Favorites


Lyn Villa
Lyn Villa
10101 Lyndale Ave S
Bloomington, MN 55420
888-702-2898
1 Bedroom $695 2 Bedrooms $875 3 Bedrooms+ $995
Check Availability
Add to Favorites


Colonial Estates Townhomes
Colonial Estates Townhomes
8500 22nd Ave
Bloomington, MN 55425
888-702-2898
3 Bedrooms+ $1025
Check Availability
Add to Favorites


Cedar Cliff
Cedar Cliff
9300 Old Cedar Ave S
Bloomington, MN 55431
888-702-2898
1 Bedroom $775 2 Bedrooms $915
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