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 = 3227 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 = 3227 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 = 3227 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;

158 Lake Merial Boulevard
Panama City, FL 32409

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,999
Beds: 5
Baths: 7
Status: Active
SqFt: 4930
Agency: Counts Real Estate Group Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2016
Notes: 158 Lake Merial Blvd, 30A Luxury without the traffic and high price, absolutely stunning ''Montego Bay'' floorplan, modern and custom build, each of the 5 bedrooms has a private bath, in total there are 6 full baths and one half bath. Begin at the gated entrance and manicured lawns, sidewalks and street lamps and enter the paver driveway with side facing oversize, 3 car garage with epoxied floor, custom metal cabinets, work bench and tool hanger. Enjoy additional privacy with lake access just across the street. Privacy fence with two fenced side yards for garden, play, custom built 300 sq ft outdoor kitchen with teak deck, heated and cooled pool bath w/ tiled shower and 2 person sauna. Quartz counters, under mount sink, Blaze refrigerator, ice maker, Napoleon Built In Outdoor Grill, Pacific Living Pizza Oven as well as a full size fireplace, all overlooking the 39' x 15' Heated Pool with 8'x8' infinity edge heated spa, 5' wide modern waterfall feature and pool jets, conveniently Bluetooth operated, comfortably entertain up to 100 people. Ample patio space with multiple access doors for home entry. Moving inside, 10'' wide plank distressed European Oak flooring, 20' vaulted ceiling with catwalk in main living room, natural light throughout, first floor media room w/ built in Polk Audio speakers. Smart home - 3 yr. old 24KW solar system (LG Panels) and 20KW with battery backup. Lavel 2 50 Amp EV Charger. CAT 7 wiring to strategic points in the ceiling to mount wireless access points to guarantee excellent cover throughout the home, working from home could never be better. AT&T has 5G Fiber coming in the neighborhood, work from home or have home school in complete luxury! Office and entertainment room has hard wired connections. There is a termination panel under the stairs for all connections and also connects to the modem in the laundry room. The kitchen is out of a magazine -Chef's kitchen with massive 10'x 6' Carrera marble island, Viking and Fisher Pakel appliances, Butler's pantry with cooktop, sink, All cabinets Blum German auto-soft close hardware and ''Sonic'' Ice Maker, 200+ bottle wine cellar with custom Ipe interior, Substantial dining, easily fitting dinners of 25+ people and just off the dining is a sitting Library / Office with double 5' x 8' shaker pocket doors. Windows abound w/ pool and outdoor entertainment views.Breath taking, massive 960 sq ft Primary suite w/ 2 private balconies combined for 320 sq ft, Shiplap feature wall, 20'' x 20'' Rainfall shower in Master with Body Jets and 6' Soaker freestanding tub.Additional interior bonuses to not overlook- Every bath has custom marble, Culligan Water filtration system ,Deep well for irrigation and pool, 100% of lighting in home LED, LaGrande Adorne Smart home lighting controls, Anderson Series 400 windows, Solid Copper feature gutters ,Series 18 super-efficient HVAC system, 5x Rinnai Gas water heating, 8' solid doors throughout12'' shaker baseboardsbull-nosed corners throughout, 8'' walk thickness, built to the latest hurricane proof building codes,loads of built-ins including mud room with shaker panels and backpack/coat hooks and shoe cubby.Outdoor bonuses to notice - 8' Teak privacy fence, 4 private balconies, Solid Concrete architectural wall around front of house, modern pavers and hand fit Ipe elevated walkways and landing. 2 Separate side yards perfect for dog runs and separate from outdoor entertainment areas. Bozeman School (K-12) is withing walking distance, gated community, private lake for residents, airport within 30 minutes! (**To Note-115 Lake Merial Place sold at 1.475mm Oct 20, 2023! This one is larger, more beds and baths and higher end construction and finishes!) Absolutely remarkable build, no boxes unchecked, this one is an opportunity, home ownership at its finest!
MlsNumber: 750220


Listing Provided By: Counts Real Estate Group Inc, original listing
Name: Counts Real Estate Group Inc
Phone: (850) 249-3615
Office Name: Counts Real Estate Group Inc
Office Phone: (850) 249-3615
Agent Name: Bubba McCants
Disclaimer: Copyright © 2024 Central Panhandle Association of REALTORS. 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 = 3227 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 Amanda Cialoni
Amanda Cialoni
ASCIISeashore Realty LLC
Call Today!: (850) 832-7447

Local Mortgage Pro

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 = 3227 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;
Real Estate Expert Photo for Daniel E Giroux NMLS#26531
Daniel E Giroux NMLS#26531
ASCIISemper Home Loans, Inc
Call Today!: (401) 578-8929

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App