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

5172 Jewell Terrace
Palm Harbor, FL 34685

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,395,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 3666
Agency: Realtec Group, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: Sophistication abounds! Welcome to luxurious living in exclusive Juniper Bay of Lansbrook. Built by Maconi Homes, nearly 3,700 sq.ft. of fine Florida living in this magnificent, executive pool home. 4 bedrooms, 3 baths, plus an office, media room, oversized 3-car garage & huge bonus room/in-law quarters. Enter through elegant double glass doors to the stunning formal living & dining area with stylish boxed and coffered ceilings. The hardwood flooring, upgraded base moldings & soaring ceilings are accented by crown molding & flooded with natural light. Triple pocket sliders open to the lanai. The chef inspired kitchen is an entertainer's delight w/ a huge island featuring pendant lighting, a raised breakfast bar, granite counters, beautiful wood cabinetry with 42" upper cabinets heightened w/ crown molding, plate racks & appliance hutches, tile backsplash, stainless appliances… a 5 burner Viking range(2021), Bosch dishwasher(2024), double convection oven, microwave (2021), & 3 door refrigerator. The eat-in area overlooks the fabulous pool, separate tower cabinetry with dual-zoned beverage fridge (2023). The kitchen opens to the family room w/ double coffered ceilings, transom windows, gas fireplace, built-in shelving and triple pocket sliders to the lanai. The lanai showcases the luxury of extending your living space outdoors, accented wood ceiling, pavers, pebbletech pool w/ raised spillover spa! Perfect for entertaining! Tranquil, lush landscaping and serene garden in the private conservation backyard with a bonus patio space ideal for soaking up the sun, grilling or enjoying a firepit. The bonus media room is a perfect entertaining space. It features transom windows, plantation shutters and built-in cabinetry. The tri-split bedroom layout provides ultimate privacy. Spacious primary bedroom has coffered ceiling, private entrance to lanai, an enormous walk-in closet with custom closet system, ensuite bath w/ wood cabinetry crown molding, oversized granite counters, makeup area, dual vanities, soaker tub, walk-in shower & water closet. Adjacent to the primary bedroom is the office/study w/ single glass door entry, wood floors and crown molding. Two secondary bedrooms share a bath w/ a tub/shower combination. A private hallway just off the kitchen/family room boasts a built-in dual desk station. Ideal for work from home or student work area! Bedroom #4 & the bonus room are in the rear of the home. Perfect for guests or in-law opportunity! The 3rd bath serves as the pool bath and has a walk-in shower. A stylish French door entry brings you to the bonus room. It is currently used as 2nd primary bedroom. Endless possibilities… office, game or playroom. Additional bedrooms each feature lovely window seats w/ storage. Laundry room has upper cabinets, folding area & utility sink. Interior Smart Home w LCD Inwall panels & switches. WIFI controllable by your devices, pool heater (2023), water softener & pool pump (2022), roof (2021), spa filter (2021), 2-Trane AC and gas water heater (2017), Pella window and doors (2017), Tesla charging station (2022). All this in fabulous Lansbrook w/ endless community features… walking & bike paths, waterfront park, playgrounds, basketball & volleyball courts, soccer field! Zoned for 'A' rated schools! Near to shopping, restaurants, hospitals, John Chestnut Park, the Pinellas Trail & an active YMCA! Tremendous location, desirable community & a well-maintained home where pride of ownership prevails! Bedroom Closet Type: Walk-in Closet (Primary Bedroom).
MlsNumber: U8236598


Listing Provided By: Realtec Group, Inc., original listing
Name: Realtec Group, Inc.
Phone: (727) 789-5555
Office Name: RE/MAX REALTEC GROUP INC
Office Phone: (727) 789-5555
Agent Name: Nancy Leslie
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 = 375 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 Brian Cooper
Brian Cooper
ASCIIRealty Experts
Call Today!: (727) 351-2728

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App