Your browser does not support the video tag.
Knowledge Center
Email Alerts
Mortgage/Credit Help
FAQ
Reviews
Professionals
Search
Refine Search
Beds:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Baths:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Property Type:
Any
Conventional
Foreclosure
Price Range:
to
Refine
DEBUG FN args: Array ( [0] => 358 [1] => LAKE (NORTH) [2] => FL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 358 LocID: LAKE (NORTH) Region: FL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 358 Region: LAKE (NORTH) State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 358 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 358 [1] => LAKE (NORTH) [2] => FL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 358 LocID: LAKE (NORTH) Region: FL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 358 Region: LAKE (NORTH) State: FL Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 358 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 358 [1] => LAKE (NORTH) [2] => FL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 358 LocID: LAKE (NORTH) Region: FL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 358 Region: LAKE (NORTH) State: FL Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 358 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Florida (FL) Foreclosure Listings
|
Lake (North)
| Mount Dora, Florida
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Mount Dora, Lake (North), Florida
Displaying 1 to 10 of 79 Properties (0 foreclosures)
eXp Realty LLC
$3,250,000
4
bd /
5
ba /
6,140
sqft
27852 Lake Jem Road
Mount Dora
,
Florida
32757
ERA Grizzard Real Estate
$2,800,489
4
bd /
3
ba /
5,689
sqft
305 Shadow Harbour Lane
Mount Dora
,
Florida
32757
Coldwell Banker Camelot Realty
$2,300,000
5
bd /
3
ba /
4,064
sqft
6878 Round Lake Road
Mount Dora
,
Florida
32757
Berkshire Hathaway HomeServices Florida Realty
$2,175,000
5
bd /
5
ba /
6,844
sqft
996 Fairview Avenue
Mount Dora
,
Florida
32757
TOUCHSTONE REAL ESTATE
$825,000
4
bd /
3
ba /
3,095
sqft
1635 Hilltop Drive
Mount Dora
,
Florida
32757
Dave Lowe Realty
$724,900
3
bd /
3
ba /
3,516
sqft
625 Sand Lake Court
Mount Dora
,
Florida
32757
Direct Sell Inc DBA Weichert Realtors Hallmark Pro
$659,900
3
bd /
3
ba /
2,477
sqft
9029 Laurel Ridge Drive
Mount Dora
,
Florida
32757
ERA Grizzard Real Estate
$650,000
2
bd /
2
ba /
2,001
sqft
4755 Britt Road
Mount Dora
,
Florida
32757
EXIT REALTY TRICOUNTY
$624,900
4
bd /
2
ba /
2,003
sqft
7766 Lake Andrea Circle
Mount Dora
,
Florida
32757
Preferred Real Estate Brokers
$614,900
3
bd /
2
ba /
1,758
sqft
2174 Wallingford Loop
Mount Dora
,
Florida
32757
«
‹
1
2
3
›
»
Cities In LAKE (NORTH), FL
Altoona
Astatula
Astor
Barberville
Candler
Eastlake Weir
Eustis
Ferndale
Fruitland Park
Grand Island
Howey In The Hills
Killarney
Lady Lake
Lake Geneva
Leesburg
Minneola
Mount Dora
Oakland
Okahumpka
Orange Springs
Paisley
Sorrento
Sparr
Tavares
Umatilla
Yalaha
mount dora
USHUD.com on the Go!