Title Page Background
HFQUERY 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 = 3336 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3336 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3336 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1645 N Highway A1a
Indialantic, FL 32903

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,900
Beds: 4
Baths: 4
Status: Active
SqFt: 2820
Agency: AmeriTeam Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: MUST SEE! WELCOME TO BEACHFRONT PARADISE!!! BEAUTIFUL DIRECT OCEAN FRONT 4/4 WITH DEN AND SPECTACULAR BEACH VIEWS THAT PROVIDE THE FEELING OF BEING IN YOUR OWN PRIVATE BEACHFRONT HOME. IMAGINE WAKING UP EVERY MORNING TO STUNNING SUNRISES WHILE SIPPING COFFEE ON YOUR OCEAN FRONT BALCONY. THE HOME IS AN ENTIRE FLOOR WITH NO SHARED WALLS. THERE IS A DEDICATED 2 CAR GARAGE WITH DIRECT LOBBY ACCESS. STEP OUT OF THE ELEVATOR INTO YOUR PRIVATE VESTIBULE. UPON ENTERING THIS OPEN FLOOR PLAN HOME, YOU ARE IMMERSED WITH BREATH TAKING BEACH VIEWS. THE PRIMARY SUITE COMMANDS OCEAN FRONT VIEWS WITH DUAL WALKIN CLOSETS, SEPARATE VANITES AND AN OVERSIZED SHOWER WITH TRIPLE SHOWER HEADS INCLUDING A RAIN FALL. TWO OVERSIZED JUNIOR SUITES WITH GENEROUS CLOSETS, PRIVATE ENSUITES AND SEPARATE BALCONY. THE FOURTH BEDROOM WOULD MAKE AN IDEAL OFFICE OR CHILD'S PLAYROOM WITH A SHARED HALL/GUEST BATHROOM. AN OPEN FLOOR DEN WHICH ALLOWS GENEROUS SPACE FOR ENTERTAINING. A CHEF'S KITCHEN COMPLETE WITH QUARTZ COUNTERTOPS AND WATERFALL ISLAND, AN EXPANSIVE PENINSULA, CUSTOM CABINETRY WITH STORAGE GALORE, SOFT CLOSE FEATURES, UNDER CABINET LED LIGHTING, CUSTOM CEILING LIGHTING AND ALL HIGH-END STAINLESS APPLIANCES INCLUDING A 40 INCH 6 BURNER GAS STOVE AND OVEN. DINING ROOM WET BAR WITH TWO ZONE BEVERAGE REFRIGERATOR AND 25 LB ICEMAKER. WIDE PLANK LIGHT OAK WOOD FLOORING, FLOOR TO CEILING WINDOWS, REMOTE CONTROLLED SHADES THROUGHOUT, REMOTE CONTROLLED HURRICANE SHUTTERS, GLASS PANEL RAILING ON OCEANSIDE TERRACE. A LAUNDRY ROOM WITH WASHER DRYER, CABINENTS AND SINK. THE UNIT IS EQUIPPED WITH 2 SEPARATE HVAC SYSTEM FOR ZONE COOLING AND HEATING. OCEAN FRONT POOL AND SPA. EXERCISE ROOM WITH SAUNA. DIRECT BEACH ACCESS FROM POOL AREA. PROPERTY SHOWS LIKE NEW CONSTRUCTION, MOVE-IN-READY!
MlsNumber: S5094363


Listing Provided By: AmeriTeam Realty, Inc., original listing
Name: AmeriTeam Realty, Inc.
Phone: (407) 898-4800
Office Name: AMERITEAM REALTY INC
Office Phone: (407) 898-4800
Agent Name: Lauri Harlow
Disclaimer: Copyright © 2024 Stellar MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY 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 = 3336 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Michael Koeppel & Jennifer Mobley
Michael Koeppel & Jennifer Mobley
ASCIIeXp Realty LLC
Call Today!: (321) 272-9656

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App