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 city = 'Little Canada' 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 ((city IN ("North Saint Paul","Little Canada","Vadnais Heights","Landfall Village","Maplewood","Saint Paul","Mahtomedi","Pine Springs","Willernie","North Oaks","Gem Lake","Birchwood","White Bear Township","Dellwood","Grant","White Bear Lake","Lake Elmo","Oakdale","West Saint Paul","Shoreview","Lauderdale","Falcon Heights","Woodbury","South Saint Paul","Mendota Heights","Lilydale","New Brighton","Mounds View","Moundsview","Roseville","Arden Hills","Newport","West Lakeland","Grant Township","Stillwater","Oak Park Heights","Saint Anthony","Saint Anthony Village","Mendota","Centerville","Hugo","Columbus","Lino Lakes","Circle Pines","Lexington","Blaine","Eagan","Hilltop","Fridley","Columbia Heights","Douglas","Bayport","Baytown","Minneapolis","Inver Grove Heights","Spring Lake Park","Saint Paul Park","Grey Cloud Island","Afton","Lakeland","St Croix Bch","Saint Marys Point","Lakeland Shores","Saint Croix Beach","St Marys Pt","Lake Saint Croix Beach","Lakeland Shrs","Fort Snelling","Sunfish Lake","Cottage Grove","Richfield","Robbinsdale","Crystal","Edina","Golden Valley","Saint Louis Park","Saint Croix","Marine on Saint Croix","Marine","New Scandia","Forest Lake","New Hope","Bloomington","Coon Rapids","Brooklyn Park","Brooklyn Center","Lakeville","Rosemount","Plymouth","Medicine Lake") AND state='MN') OR (city IN ("Houlton","Boardman","Burkhardt","North Hudson","Hudson","Somerset") AND state='WI')) AND citystate!=CONCAT('Little Canada','MN')

Little Canada Apartments for Rent | Apartments in Little Canada, MN

Home

View My Favorites

Owners & Managers

Blog

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


Apartments in Little Canada, MN


City Information - Hide
Home of the Little Canada Historical Society and the community celebration Canada Days, this city has it all. With less than a 20 minute drive from Minneapolis, Little Canada apartments are conveniently located and the city has many parks and trails for recreational activities. You can be a part of this exciting community on a daily basis; browse through our Little Canada Apartments for rent and find the perfect apartment that you can call home.

Featured Properties

Exact Match Close Match

51af3ee24da4751af3f66cc27e51af3fb77759d

Exact Match


Cedars Lakeside
Cedars Lakeside
2800 Rustic Place
Little Canada, MN 55117
Studio $819-$859 1 Bedroom $899-$1044 2 Bedrooms $1029-$1219 3 Bedrooms+ $1429-$1494
888-800-2836
Check Availability
Add to Favorites


Canabury Hill
Canabury Hill
165 E Cty Rd B2
Little Canada, MN 55117
Studio $609-$649 1 Bedroom $699-$729 2 Bedrooms $849-$909
888-815-4269
Check Availability
Add to Favorites


Grand Pre East
Grand Pre East
215 E Cty Rd B2
Little Canada, MN 55117
Studio $629-$719 1 Bedroom $709-$829 2 Bedrooms $949-$1029 3 Bedrooms+ $1369
888-608-9736
Check Availability
Add to Favorites


Village Manor
Village Manor
2327 East 11th Avenue
North Saint Paul, MN 55109
1 Bedroom $659-$669 2 Bedrooms $770-$795
888-904-6442
Check Availability
Add to Favorites


Parkside Apartments
Parkside Apartments
2334 11th Ave E
North Saint Paul, MN 55109
1 Bedroom $565-$580
651-789-5759
Check Availability
Add to Favorites


Silver Ridge
Silver Ridge
2330 Stillwater Ave E
Maplewood, MN 55119
1 Bedroom $739-$769 2 Bedrooms $849-$889
888-608-6653
Check Availability
Add to Favorites


Shamrock Court Apartments
Shamrock Court Apartments
2236 Lower Afton Road
Saint Paul, MN 55119
1 Bedroom $650-$700 2 Bedrooms $775-$825 3 Bedrooms+ $925-$985
888-691-4061
Check Availability
Add to Favorites


MacLaren Hill
MacLaren Hill
1351 Carling Dr
Saint Paul, MN 55108
Studio $789-$859 1 Bedroom $909-$959 2 Bedrooms $1229-$1474 3 Bedrooms+ $1679
888-248-5507
Check Availability
Add to Favorites


Lowertown Commons
Lowertown Commons
300 East 4th Street
Saint Paul, MN 55101
Studio $935 1 Bedroom $1025-$1175 2 Bedrooms $1595-$1685
(888) 479-4195
Check Availability
Add to Favorites


Galtier Towers Apartments
Galtier Towers Apartments
172 E Sixth St
Saint Paul, MN 55101
Studio $670-$930 1 Bedroom $865-$1245 2 Bedrooms $1260-$1730
888-412-7014
Check Availability
Add to Favorites


Mears Park Place
Mears Park Place
401 Sibley St
Saint Paul, MN 55101
Studio $790-$970 1 Bedroom $890-$1235 2 Bedrooms $1165-$1400
888-318-2790
Check Availability
Add to Favorites


Kellogg Square
Kellogg Square
111 East Kellogg Boulevard
Saint Paul, MN 55101
Studio $835-$1115 1 Bedroom $975-$1250 2 Bedrooms $1200-$3495 3 Bedrooms+ $1490-$2725
888-695-0017
Check Availability
Add to Favorites


The Kendrick
The Kendrick
1351 Carling Dr
Saint Paul, MN 55108
1 Bedroom $889-$1124 2 Bedrooms $1099-$1134
888-690-8658
Check Availability
Add to Favorites


East Side Commons
East Side Commons
868 Bradley Street
Saint Paul, MN 55101
Studio $592 1 Bedroom $695 2 Bedrooms $721-$811 3 Bedrooms+ $923-$1015
888-809-5647
Check Availability
Add to Favorites


Bradley House
Bradley House
2150 Wilson Avenue
Saint Paul, MN 55119
1 Bedroom $739 2 Bedrooms $889
888-729-3506
Check Availability
Add to Favorites


Wheelock Parkway
Wheelock Parkway
1609-104 Woodbridge Street
Saint Paul, MN 55117
1 Bedroom $680-$730 2 Bedrooms $855-$865
888-437-0121
Check Availability
Add to Favorites


Hill Plaza
Hill Plaza
400 Selby Avenue
Saint Paul, MN 55102
1 Bedroom $889-$930 2 Bedrooms $1089-$1219
888-857-8593
Check Availability
Add to Favorites


Tilsner Artist Lofts
Tilsner Artist Lofts
300 Broadway Street N.
Saint Paul, MN 55101
Studio $850 1 Bedroom $915 2 Bedrooms $1086
888-348-4084
Check Availability
Add to Favorites


Highland Ridge Apartments
Highland Ridge Apartments
2285 Stewart Avenue
Saint Paul, MN 55116
1 Bedroom $1095-$1315 2 Bedrooms $1415-$1515 3 Bedrooms+ $1695-$1720
888-719-4239
Check Availability
Add to Favorites


The Plaza
The Plaza
2353 Youngman Avenue
Saint Paul, MN 55116
1 Bedroom $1105-$1350 2 Bedrooms $1495-$2275
888-594-8775
Check Availability
Add to Favorites


Exact Match


Cedars Lakeside
Cedars Lakeside
2800 Rustic Place
Little Canada, MN 55117
888-800-2836
Studio $819-$859 1 Bedroom $899-$1044 2 Bedrooms $1029-$1219 3 Bedrooms+ $1429-$1494
Check Availability
Add to Favorites


Canabury Hill
Canabury Hill
165 E Cty Rd B2
Little Canada, MN 55117
888-815-4269
Studio $609-$649 1 Bedroom $699-$729 2 Bedrooms $849-$909
Check Availability
Add to Favorites


Grand Pre East
Grand Pre East
215 E Cty Rd B2
Little Canada, MN 55117
888-608-9736
Studio $629-$719 1 Bedroom $709-$829 2 Bedrooms $949-$1029 3 Bedrooms+ $1369
Check Availability
Add to Favorites


Close Match


Village Manor
Village Manor
2327 East 11th Avenue
North Saint Paul, MN 55109
888-904-6442
1 Bedroom $659-$669 2 Bedrooms $770-$795
Check Availability
Add to Favorites


Parkside Apartments
Parkside Apartments
2334 11th Ave E
North Saint Paul, MN 55109
651-789-5759
1 Bedroom $565-$580
Check Availability
Add to Favorites


Silver Ridge
Silver Ridge
2330 Stillwater Ave E
Maplewood, MN 55119
888-608-6653
1 Bedroom $739-$769 2 Bedrooms $849-$889
Check Availability
Add to Favorites


Shamrock Court Apartments
Shamrock Court Apartments
2236 Lower Afton Road
Saint Paul, MN 55119
888-691-4061
1 Bedroom $650-$700 2 Bedrooms $775-$825 3 Bedrooms+ $925-$985
Check Availability
Add to Favorites


MacLaren Hill
MacLaren Hill
1351 Carling Dr
Saint Paul, MN 55108
888-248-5507
Studio $789-$859 1 Bedroom $909-$959 2 Bedrooms $1229-$1474 3 Bedrooms+ $1679
Check Availability
Add to Favorites


Lowertown Commons
Lowertown Commons
300 East 4th Street
Saint Paul, MN 55101
(888) 479-4195
Studio $935 1 Bedroom $1025-$1175 2 Bedrooms $1595-$1685
Check Availability
Add to Favorites


Galtier Towers Apartments
Galtier Towers Apartments
172 E Sixth St
Saint Paul, MN 55101
888-412-7014
Studio $670-$930 1 Bedroom $865-$1245 2 Bedrooms $1260-$1730
Check Availability
Add to Favorites


Mears Park Place
Mears Park Place
401 Sibley St
Saint Paul, MN 55101
888-318-2790
Studio $790-$970 1 Bedroom $890-$1235 2 Bedrooms $1165-$1400
Check Availability
Add to Favorites


Kellogg Square
Kellogg Square
111 East Kellogg Boulevard
Saint Paul, MN 55101
888-695-0017
Studio $835-$1115 1 Bedroom $975-$1250 2 Bedrooms $1200-$3495 3 Bedrooms+ $1490-$2725
Check Availability
Add to Favorites


The Kendrick
The Kendrick
1351 Carling Dr
Saint Paul, MN 55108
888-690-8658
1 Bedroom $889-$1124 2 Bedrooms $1099-$1134
Check Availability
Add to Favorites


East Side Commons
East Side Commons
868 Bradley Street
Saint Paul, MN 55101
888-809-5647
Studio $592 1 Bedroom $695 2 Bedrooms $721-$811 3 Bedrooms+ $923-$1015
Check Availability
Add to Favorites


Bradley House
Bradley House
2150 Wilson Avenue
Saint Paul, MN 55119
888-729-3506
1 Bedroom $739 2 Bedrooms $889
Check Availability
Add to Favorites


Wheelock Parkway
Wheelock Parkway
1609-104 Woodbridge Street
Saint Paul, MN 55117
888-437-0121
1 Bedroom $680-$730 2 Bedrooms $855-$865
Check Availability
Add to Favorites


Hill Plaza
Hill Plaza
400 Selby Avenue
Saint Paul, MN 55102
888-857-8593
1 Bedroom $889-$930 2 Bedrooms $1089-$1219
Check Availability
Add to Favorites


Tilsner Artist Lofts
Tilsner Artist Lofts
300 Broadway Street N.
Saint Paul, MN 55101
888-348-4084
Studio $850 1 Bedroom $915 2 Bedrooms $1086
Check Availability
Add to Favorites


Highland Ridge Apartments
Highland Ridge Apartments
2285 Stewart Avenue
Saint Paul, MN 55116
888-719-4239
1 Bedroom $1095-$1315 2 Bedrooms $1415-$1515 3 Bedrooms+ $1695-$1720
Check Availability
Add to Favorites


The Plaza
The Plaza
2353 Youngman Avenue
Saint Paul, MN 55116
888-594-8775
1 Bedroom $1105-$1350 2 Bedrooms $1495-$2275
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