select DISTINCT(t.sysid) as sysid, t.1, t.144,t.167,t.881,t.922,t.924,Zip,bd,bh, t.137, tp, numpics, t.246,t.157 from (SELECT sysid, `1`, `144`,`167`,`881`,`922`,`924`,`10` as Zip, `25` as bd,`92` as bh, `137`, `276` as tp, numpics, `246`,`157` FROM RE1 WHERE sysid != 343645459 AND numpics>0 AND `137`>0 AND CONCAT(`922`,',',`924`) LIKE '%Miami%' UNION ALL SELECT sysid, `1`, `144`,`167`,`881`,`922`,`924`,`10` as Zip,`25` as bd,`92` as bh, `137`, `370` as tp, numpics, `246`,`157` FROM RE2 WHERE sysid != 343645459 AND numpics>0 AND `137`>0 AND CONCAT(`922`,',',`924`) LIKE '%Miami%' UNION ALL SELECT sysid, `1`, `144`,`167`,`881`,`922`,`924`,`10` as Zip, 0 as bd, 0 as bh, `137`, `1` as tp, numpics, `246`,`157` FROM RLD WHERE sysid != 343645459 AND numpics>0 AND `137`>0 AND CONCAT(`922`,',',`924`) LIKE '%Miami%' UNION ALL SELECT sysid, `1`, `144`,`167`,`881`,`922`,`924`,`10` as Zip, 0 as bd, 0 as bh, `137`, `1` as tp, numpics, `246`,`157` FROM RIN WHERE sysid != 343645459 AND numpics>0 AND `137`>0 AND CONCAT(`922`,',',`924`) LIKE '%Miami%' ) as t ORDER BY sysid DESC

Miami FL Open Houses

Search Open House Listings in Miami FL. Check Open House dates and times, recently
sales data, tax history and contact your real estate for more information.

Sep 24, 2017 | 12:30PM - 4:00PM
16941 SW 92 Street Circle. Miami, Florida - Hometaurus 16941 SW 92 Street Circle. Miami, Florida
18 photos

16941 SW 92 Street Circle Miami, Florida 33196

Miami, Florida 33196
5 bd | 4 ba
Single Family Home
Jill Penman
(305) 666-0562
16941 SW 92 Street Circle. Miami, Florida
Jill Penman
$489,900
Sep 24, 2017 | 2:00PM - 4:00PM
9444 SW 123rd Ter. Miami, Florida - Hometaurus 9444 SW 123rd Ter. Miami, Florida
22 photos

9444 SW 123rd Ter Miami, Florida 33176

Miami, Florida 33176
4 bd | 4 ba
Single Family Home
Lizzie Padro
(305) 253-2800
9444 SW 123rd Ter. Miami, Florida
Lizzie Padro
$1,340,000
Sep 24, 2017 | 12:30PM - 5:00PM
16941 SW 92 Street Circle. Miami, Florida - Hometaurus 16941 SW 92 Street Circle. Miami, Florida
18 photos

16941 SW 92 Street Circle Miami, Florida 33196

Miami, Florida 33196
5 bd | 4 ba
Single Family Home
Jill Penman
(305) 666-0562
16941 SW 92 Street Circle. Miami, Florida
Jill Penman
$489,900
Sep 24, 2017 | 3:30PM - 5:30PM
9400 SW 106th Ct. Miami, Florida - Hometaurus 9400 SW 106th Ct. Miami, Florida
22 photos

9400 SW 106th Ct Miami, Florida 33176

Miami, Florida 33176
4 bd | 2 ba
Single Family Home
Cheryl Johnson
(305) 596-3333
9400 SW 106th Ct. Miami, Florida
Cheryl Johnson
$460,000
Sep 24, 2017 | 12:30PM - 5:00PM
16941 SW 92 Street Circle. Miami, Florida - Hometaurus 16941 SW 92 Street Circle. Miami, Florida
18 photos

16941 SW 92 Street Circle Miami, Florida 33196

Miami, Florida 33196
5 bd | 4 ba
Single Family Home
Jill Penman
(305) 666-0562
16941 SW 92 Street Circle. Miami, Florida
Jill Penman
$489,900
Sep 24, 2017 | 2:00PM - 4:00PM
9444 SW 123rd Ter. Miami, Florida - Hometaurus 9444 SW 123rd Ter. Miami, Florida
22 photos

9444 SW 123rd Ter Miami, Florida 33176

Miami, Florida 33176
4 bd | 4 ba
Single Family Home
Lizzie Padro
(305) 253-2800
9444 SW 123rd Ter. Miami, Florida
Lizzie Padro
$1,340,000
Sep 24, 2017 | 3:30PM - 5:30PM
9400 SW 106th Ct. Miami, Florida - Hometaurus 9400 SW 106th Ct. Miami, Florida
22 photos

9400 SW 106th Ct Miami, Florida 33176

Miami, Florida 33176
4 bd | 2 ba
Single Family Home
Cheryl Johnson
(305) 596-3333
9400 SW 106th Ct. Miami, Florida
Cheryl Johnson
$460,000
Sep 27, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #1802. Miami, Florida - Hometaurus 24 SW 4 Street #1802. Miami, Florida
12 photos

24 SW 4 Street #1802 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #1802. Miami, Florida
Sabine Otamendi
$1,784,000
Sep 27, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #3402. Miami, Florida - Hometaurus 24 SW 4 Street #3402. Miami, Florida
12 photos

24 SW 4 Street #3402 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #3402. Miami, Florida
Sabine Otamendi
$1,976,000
Sep 27, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #1802. Miami, Florida - Hometaurus 24 SW 4 Street #1802. Miami, Florida
12 photos

24 SW 4 Street #1802 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #1802. Miami, Florida
Sabine Otamendi
$1,784,000
Sep 27, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #5006. Miami, Florida - Hometaurus 24 SW 4 Street #5006. Miami, Florida
12 photos

24 SW 4 Street #5006 Miami, Florida 33130

Miami, Florida 33130
2 bd | 2 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #5006. Miami, Florida
Sabine Otamendi
$1,548,000
Sep 30, 2017 | 12:00PM - 4:00PM
59 N Shore Drive #28e. Miami Beach, Florida - Hometaurus 59 N Shore Drive #28e. Miami Beach, Florida
21 photos

59 N Shore Drive #28e Miami Beach, Florida 33141

Miami Beach, Florida 33141
3 bd | 3 ba
Townhome
Katarzyna Weszczak
(305) 695-6300
59 N Shore Drive #28e. Miami Beach, Florida
Katarzyna Weszczak
$799,000
Oct 01, 2017 | 3:00PM - 5:00PM
4895 Pine Drive. Miami, Florida - Hometaurus 4895 Pine Drive. Miami, Florida
9 photos

4895 Pine Drive Miami, Florida 33143

Miami, Florida 33143
7 bd | 8 ba
Single Family Home
Howard Wolofsky
(305) 960-2400
4895 Pine Drive. Miami, Florida
Howard Wolofsky
$5,295,000
Oct 25, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #5006. Miami, Florida - Hometaurus 24 SW 4 Street #5006. Miami, Florida
12 photos

24 SW 4 Street #5006 Miami, Florida 33130

Miami, Florida 33130
2 bd | 2 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #5006. Miami, Florida
Sabine Otamendi
$1,548,000
Oct 25, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #1802. Miami, Florida - Hometaurus 24 SW 4 Street #1802. Miami, Florida
12 photos

24 SW 4 Street #1802 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #1802. Miami, Florida
Sabine Otamendi
$1,784,000
Oct 25, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #3402. Miami, Florida - Hometaurus 24 SW 4 Street #3402. Miami, Florida
12 photos

24 SW 4 Street #3402 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #3402. Miami, Florida
Sabine Otamendi
$1,976,000
Oct 25, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #5006. Miami, Florida - Hometaurus 24 SW 4 Street #5006. Miami, Florida
12 photos

24 SW 4 Street #5006 Miami, Florida 33130

Miami, Florida 33130
2 bd | 2 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #5006. Miami, Florida
Sabine Otamendi
$1,548,000
Oct 25, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #1802. Miami, Florida - Hometaurus 24 SW 4 Street #1802. Miami, Florida
12 photos

24 SW 4 Street #1802 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #1802. Miami, Florida
Sabine Otamendi
$1,784,000
Oct 25, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #3402. Miami, Florida - Hometaurus 24 SW 4 Street #3402. Miami, Florida
12 photos

24 SW 4 Street #3402 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #3402. Miami, Florida
Sabine Otamendi
$1,976,000
Nov 15, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #5006. Miami, Florida - Hometaurus 24 SW 4 Street #5006. Miami, Florida
12 photos

24 SW 4 Street #5006 Miami, Florida 33130

Miami, Florida 33130
2 bd | 2 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #5006. Miami, Florida
Sabine Otamendi
$1,548,000
Nov 15, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #1802. Miami, Florida - Hometaurus 24 SW 4 Street #1802. Miami, Florida
12 photos

24 SW 4 Street #1802 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #1802. Miami, Florida
Sabine Otamendi
$1,784,000
Nov 15, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #5006. Miami, Florida - Hometaurus 24 SW 4 Street #5006. Miami, Florida
12 photos

24 SW 4 Street #5006 Miami, Florida 33130

Miami, Florida 33130
2 bd | 2 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #5006. Miami, Florida
Sabine Otamendi
$1,548,000
Nov 15, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #1802. Miami, Florida - Hometaurus 24 SW 4 Street #1802. Miami, Florida
12 photos

24 SW 4 Street #1802 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #1802. Miami, Florida
Sabine Otamendi
$1,784,000
Nov 15, 2017 | 11:00AM - 3:00PM
24 SW 4 Street #3402. Miami, Florida - Hometaurus 24 SW 4 Street #3402. Miami, Florida
12 photos

24 SW 4 Street #3402 Miami, Florida 33130

Miami, Florida 33130
3 bd | 3 ba
Condo
Sabine Otamendi
(954) 874-0740
24 SW 4 Street #3402. Miami, Florida
Sabine Otamendi
$1,976,000
Aug 27, 2018 | 12:00PM - 3:00PM
16180 SW 147th Ave. Miami, Florida - Hometaurus 16180 SW 147th Ave. Miami, Florida
14 photos

16180 SW 147th Ave Miami, Florida 33187

Miami, Florida 33187
4 bd | 2 ba
Single Family Home
Isabel Barreto
(305) 408-5354
16180 SW 147th Ave. Miami, Florida
Isabel Barreto
$458,000


plumbers electricians gansoo
real estate agent hometaurus video
...
...
...
Please enter email to request your password
error
Invalid Email