Airye Condos

168 East 6th Street
St Paul MN,55423
www.airyecondos.com
612-735-0553 Sales & Rentals

Find Homes - Search All Condos, Townhomes & Homes For Sale -

By searching you agree to the end user license agreement.
Sort By

For Sale

Featured q: select * from listing where Latitude > 44.860477 && Latitude < 45.066473 && Longitude > -93.453827 && Longitude < -92.947083 && ( LAG = '22904' or LAG = '42627' or LAG = '46414' or LAG = '24718') order by LP desc limit 2 ;

featured
1/9 Photos
406 Wacouta St Unit 716 St. Paul, MN 55101
  • 2 beds
  • 2 baths
  • 1451 sq ft
Historic River Park Lofts w/exposed brick & beam. Fabulous penthouse unit w/spectacular views from balcony & roof top deck! Stained floors, granite tops, impressive staircase, enlarged 2nd level w/custom built-ins, & laundry room. 2 parking stalls.
$430,000

featured
1/9 Photos
406 Wacouta St Unit 110 St. Paul, MN 55101
  • 3 beds
  • 3 baths
  • 2117 sq ft
Historic urban lofts with exposed brick & beam in Lowertown, across from Mears park & connected to skyway. Dogs ok. Fabulous 3 bedroom & 3 bath unit, walk-in closet, spiral stairs to 2nd level, great kitchen.
$399,900

Default search: Latitude > 44.860477 && Latitude < 45.066473 && Longitude > -93.453827 && Longitude < -92.947083
Q: select * from listing where Latitude > 44.860477 && Latitude < 45.066473 && Longitude > -93.453827 && Longitude < -92.947083 order by LP desc limit 0,12
1/9 Photos
205 Salem Church Rd Sunfish Lake, MN 55118
  • 4 beds
  • 2 1/2 baths
  • 9287 sq ft
MIHM CUSTOM HOMES masterpiece on 9.75 extensively landscaped acres in prime Sunfish Lake. Very open throughtful design incorporates fabulous finishes throughtout. It is truely a sensational property.
$5,450,000

1/9 Photos
2505 E Lake Of The Isles Pkwy Minneapolis, MN 55405
  • 5 beds
  • 3 1/2 baths
  • 6500 sq ft
Distinguished by its unparalleled 1.27 acre site, this 6400 + sq. ft. urban estate offers the utmost in both privacy and sophistication. A timeless contemporary home coupled with a private courtyard pool and the widest panoramic lake views imaginable.
$5,300,000

1/9 Photos
5152 Schaefer Rd Edina, MN 55436
  • 5 beds
  • 3 1/2 baths
  • 7289 sq ft
SET ON EXTRAORDINARY 4.4 ACRES FRAMED BY WOODS & WATER -- ARCHITECT DESIGNED -- SUPERB MATERIALS & CRAFTSMANSHIP -- OUTSTANDING MAIN LVL MASTER SUITE -- BRS INCLUDE PRIVATE BATHS -- STUNNING POOL W/GRANITE TERRACE & PERGOLA -- EXTENSIVE AMENITIES THRUOUT
$4,795,000

1/9 Photos
700 2nd St S Unit W100 Minneapolis, MN 55414
  • 2 beds
  • 1 1/2 baths
  • 4200 sq ft
Premier Washburn Lofts penthouse condominium represents the entire top floor w/panoramic 270-degree views of the Mississippi River & Minneapolis skyline. Included is approximately 3200 sf of outdoor living space, complete w/terrace, lawn & water features.
$4,500,000

1/9 Photos
6605 Dakota Trl Edina, MN 55439
  • 6 beds
  • 4 1/2 baths
  • 10035 sq ft
Custom Designed Charles Cudd Home & Carriage house on Private 2-acre setting in Indian Hills.(2 parcels are included in the price.Stats & sq footage reflect a combination of both homes).Stunning detail & amenities!One of Edinas finest Properties!See supp
$4,250,000

1/9 Photos
5020 BLAKE Rd Edina, MN 55436
  • 6 beds
  • 4 1/2 baths
  • 8965 sq ft
PARK-LIKE 5BR/8 BA ESTATE SET ON APPROXIMATELY 3 ACRES OVERLOOKING MIRROR LAKE. CUSTOM RENOVATIONS IN 2005 INCLUDE MASTER SUITE, BATHS, DRESSING ROOM, KITCHEN, GARAGE AND CARRIAGE HOUSE. PRIVATE GROUNDS SURROUND THIS SPECTACULAR HOME.
$4,250,000

1/4 Photos
222 2nd St SE Unit 1701 Minneapolis, MN 55414
  • 3 beds
  • 2 1/2 baths
  • 6254 sq ft
Downtowns best in the premier riverfront building. Make this your custom home! Penthouse elevator access, top of the line finishes and exceptional outdoor spaces. Incredible location and amazing views! Shell pricing available on request.
$3,999,990

1/9 Photos
1106 Mount Curve Ave Minneapolis, MN 55403
  • 4 beds
  • 3 1/2 baths
  • 9026 sq ft
Over an acre of privacy situated in Lowry Hill. Gorgeous estate and grounds complete w/state of the art cabana, in ground pool and hot tubs all overlooking downtown. High end finishes including marble floors, steam showers, granite and custom fixtures.
$3,995,000

1/9 Photos
1 Overholt Pass Edina, MN 55439
  • 6 beds
  • 2 1/2 baths
  • 9802 sq ft
One of the highest points in Edina with incredible views from every room. Elegant entertaining spaces. Brazilian cherry hardwood floors. Wine cellar. Great outdoor spaces including terraces, sport court and putting green.
$3,995,000

1/7 Photos
13 Paddock Rd Edina, MN 55436
  • 6 beds
  • 3 1/2 baths
  • 7580 sq ft
Landmark Rolling Green setting offers great privacy and views together with incomparable recreational grounds with venues for tennis, swimming, casual or formal garden entertaining, even a "mini range" to sharpen up the short game. See supplement!
$3,990,000

1/1 Photos
3340 Republic Ave St. Louis Park, MN 55426
Lease or Purchase 2,000- 21,432 square feet of medical/professional office space with great visibility from Highway 7 and Louisiana. Located near Methodist Hospital.
$3,964,920

1/8 Photos
6429 Indian Hills Rd Edina, MN 55439
  • 6 beds
  • 3 1/2 baths
  • 10263 sq ft
Exquisite Smuckler built Italian stone residence in Indian Hills. Every detail and finish has been designed & executed with the highest level of craftsmanship. Gorgeous 1.02 acre grounds boasts in-ground pool, hot tub, outdoor stone fireplace and koi pond
$3,750,000

result_tab - sale
list_pg - list
site_agent_row
Array
(
    [0] => Latitude > 44.860477 && Latitude < 45.066473 && Longitude > -93.453827 && Longitude < -92.947083 
    [default_search] => Latitude > 44.860477 && Latitude < 45.066473 && Longitude > -93.453827 && Longitude < -92.947083 
    [1] => 640
    [default_width] => 640
    [specialty_site] => 
    [fname] => Customer
    [lname] => Service
    [cell] => 612-735-0553
    [email] => condobuzz@gmail.com,ckempenich@cbburnet.com
)
row count: 10258
total pages: 855
number of numbers:	6
_REQUESTArray
(
)

site_agent_rowArray
(
    [0] => Latitude > 44.860477 && Latitude < 45.066473 && Longitude > -93.453827 && Longitude < -92.947083 
    [default_search] => Latitude > 44.860477 && Latitude < 45.066473 && Longitude > -93.453827 && Longitude < -92.947083 
    [1] => 640
    [default_width] => 640
    [specialty_site] => 
    [fname] => Customer
    [lname] => Service
    [cell] => 612-735-0553
    [email] => condobuzz@gmail.com,ckempenich@cbburnet.com
)

_SESSIONArray
(
    [last_orderby] =>  order by LP desc 
    [last_where] =>  where Latitude > 44.860477 && Latitude < 45.066473 && Longitude > -93.453827 && Longitude < -92.947083 
)

_SERVERArray
(
    [PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins
    [HTTP_X_CC_ID] => ccc04-01
    [HTTP_HOST] => www.airyecondos.com
    [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
    [HTTP_ACCEPT_ENCODING] => gzip
    [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
    [HTTP_CONNECTION] => close
    [HTTP_CACHE_CONTROL] => no-cache
    [HTTP_PRAGMA] => no-cache
    [PATH] => /sbin:/usr/sbin:/bin:/usr/bin
    [SERVER_SIGNATURE] => 
Apache/2.2.9 (Fedora) Server at www.airyecondos.com Port 80


    [SERVER_SOFTWARE] => Apache/2.2.9 (Fedora)
    [SERVER_NAME] => www.airyecondos.com
    [SERVER_ADDR] => 216.69.164.185
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 38.107.191.111
    [DOCUMENT_ROOT] => /var/www/vhosts/airyecondos.com/httpdocs
    [SERVER_ADMIN] => root@localhost
    [SCRIPT_FILENAME] => /var/www/vhosts/airyecondos.com/httpdocs/index.php
    [REMOTE_PORT] => 2343
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [REQUEST_URI] => /
    [SCRIPT_NAME] => /index.php
    [PHP_SELF] => /index.php
    [REQUEST_TIME] => 1280603473
)


Recent Blog & News