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

20953 Broadwater Drive
Land O Lakes, FL 34638
Raymond Mihara with MIHARA & ASSOCIATES INC., original listing - (813) 960-2300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,040,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3746 Square Feet
Agency: MIHARA & ASSOCIATES INC.
Agency Phone: (813) 960-2300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Step into this meticulously designed Arthur Rutenberg St. Augustine VI, situated in the coveted GATED waterfront community of Pasco Sunset Lakes. Sitting on an expansive 0.36-acre lot, the home boasts stunning backyard views of a serene lake and sparkling fountain. From the decorative paver driveway, walkway, and swaying palms to the charming sitting area, every detail leads to the elegant portico-covered entrance. Through the leaded glass double doors, with a transom window, you're welcomed into a tiled foyer with an elegant floor medallion. This 3,746-sq ft residence offers 4 bedrooms/3.5 baths/3-car garage with architectural details include crown molding, intricate tray ceilings, Plantation shutters, art niches, decorative molding, rounded corners, archways, and stately columns. Large 18” diagonal tile flows through the main living areas, while rich hardwood floors add warmth to the primary bedroom, office, and bedroom 4. The elegant formal living room features an electric fireplace framed by a stunning wood cabinetry wall with display shelves, and sweeping views of the lanai, pool, and beyond through triple sliding glass doors. The adjacent “cafe” divided by stately columns, showcases bay windows overlooking the lanai, creating the perfect spot for casual dining. The chef’s kitchen is a culinary masterpiece, equipped with stainless appliances, including a 5-burner gas cooktop, range hood, dishwasher, built-in wall oven and microwave and features tall wood cabinets with crown, granite counters, tile backsplash with deco accents, large prep island with sink, spacious walk-in pantry, and high breakfast counter. A Butler’s pantry/bar with pass-thru cabinetry, wine frig, and 2-sided cabinets provides for effortless entertaining. The family room features a wall-length wood built-in entertainment center with cabinets, shelves, and pull-out compartment for components concealing wiring, complemented by a tray ceiling, paddle fan, two sets of triple sliding glass doors creating seamless indoor-outdoor living. A 3-way split bedroom plan ensures privacy and comfort for all. The primary tranquil retreat has a bay window sitting area, intricate tray ceiling, and lanai access. A mirrored hallway leading to the luxurious ensuite bath boasts two spacious walk-in closets with built-ins/organizers, and linen closet. Indulge yourself in the soaking garden tub framed by columns, beneath an exquisite stained-glass window seen in the exterior front, a walk-in tiled shower, built-in shelves, private water closet, separate vanities, and a recessed tray ceiling. Bedrooms 2-3 feature generous closets, ceiling fans, and Jack and Jill Bath with a pocket door separating the shower and toilet for added privacy. Expanded bedroom 4, offers wood floors, a Cathedral ceiling, large walk-in closet, wainscoting, and Plantation shutters making it a standout space. The backyard oasis is perfect for entertaining. A covered lanai with paver deck surrounds the heated saltwater freeform pool, complete with spillover spa, and adjacent stunning rock waterfall. The expansive lanai is equipped with a wood-burning fireplace, hosts a 6-column pavilion, an outdoor kitchen, gas grill, vent hood, sink, and a tile topped countertop. Amenities include the Sunset Beach Club, park/playground, sand volleyball, basketball, boat ramp, dock, picnic pavilions, access to Big Lake Vienna. Easy commute, minutes from major highways, shopping, and dining. Your dream home awaits!
MlsNumber: --
ListingId: TB8329972


Listing Provided By: MIHARA & ASSOCIATES INC., original listing
Phone: (813) 960-2300
Office Phone: (813) 960-2300
Agent Name: Raymond Mihara
Disclaimer: Copyright © 2025 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 = 3341 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 Hector Mojica
Hector Mojica
ASCII54 Realty
Call Today!: (813) 335-9700

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 = 3341 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 Joe Spellman NMLS# 2142845
Joe Spellman NMLS# 2142845
ASCIIFamily First Mortgage USA empowered by NEXA
Call Today!: (863) 559-8288

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App