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 = 3239 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 3239 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 3239 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

6831 Boulder Run Loop
Wesley Chapel, FL 33545

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $489,500
Beds: 4
Baths: 3
Status: Active
SqFt: 2618
Agency: FUTURE HOME REALTY INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2010
Notes: WONDERFULLY FUNCTIONAL OPEN FLOOR PLAN! POND & LITTORAL SHELF VIEW LOT! A GREAT HOME IN A GREAT COMMUNITY! SELLER OFFERING $5,000 IN SELLER CONCESSIONS! This Very Well Maintained “Award Winning” Devonshire Model built by Inland in 2010 is located in the Highly Desirable and Established Oak Creek Community of Wesley Chapel in Pasco County. Inland designed the Floor Plan of this home to be FULLY Functional in all aspects: 4 Bedrooms + STUDY/DEN (which can be used as a 5th Bedroom); Over 2600 Square Feet of Living and Entertaining Space; 3-way Split Location of the Primary Suite, Secondary Bedrooms, and Den/Office which provides Privacy for everyone; Open Floor Plan for the Kitchen and Family Room Combination; Formal Living Room and Dining Room Combination; 3 Full Bathrooms - Primary Suite Bathroom, 2nd Bathroom shared by the 2nd & 3rd Bedrooms, and a convenient 3rd Bathroom with easy access from the Patio or for use as a Guest Bedroom for the 4th Bedroom (which becomes a Junior Suite Area); and a LARGE 3 Car Garage with ample parking space in the driveway. The Spacious Kitchen consists of 42" Cabinets with Crown Molding, Granite Countertops, Custom Tile Backsplash, Gigantic Counter-Height Breakfast Bar, Eat-in Dinette area, Stainless Steel Sink, and Stainless Steel Appliances which include a French Door Refrigerator. Large Double Sliding Glass Doors off the Family Room open to a Covered and Screened-in Lanai Patio with private and tranquil Pond and Littoral Shelf Views! Huge Primary Suite with Large Walk-in Closet, Vanity with Dual Sinks and Make-up Vanity Area, and separate Shower and Garden Tub. Study/Den is located at the Front of the Home and features French Doors. Additional Elegant Design Features and Upgrades include Luxury Vinyl Plank (LVP) or Tile Flooring throughout the Home, 12' High Ceilings, Recessed Lighting, Upgraded Light Fixtures, Archways, Tray Ceilings, Gutters, Water Softener, Electronic Doorbell, and Nest Thermostat. The yard is fully vinyl fenced. New Vinyl Windows with Lifetime Warranty (2022) | Kitchen Granite Countertops and Custom Backsplash (2020) | Luxury Vinyl Plank (LVP) Flooring (2020) | A/C (2018) | Hot Water Heater (2018). Oak Creek offers many amenities for its residents, including a Community Pool, 2 Picnic Pavilions, Dog Park, Covered Playground, Swings, Walking Trails with Boardwalk, and a Basketball Court - which is also lined for Pickleball. Conveniently located with close proximity to the Great Shopping, Restaurants, Entertainment, Schools, Colleges, and Hospitals located in Wesley Chapel, Zephyrhills, and Dade City. Oak Creek is centrally located within a 10-15 minute drive to both Epperson and Mirada Lagoons, 20 minute drive to 3 malls, 30 minute drive to Busch Gardens and Adventure Island, 45-50 minute drive to Tampa International Airport, 1 hour drive to Disney, 1 hour drive to Clearwater Beach, 1 1/4 hour drive to Sea World, and 1 1/2 hour drive to Universal. A MUST SEE Home! Call TODAY for your private showing! You may also View this Matterport 3D Video Link for an immediate Virtual Tour and Showing from the comfort of your current home --- https://my.matterport.com/show/?m=L3j2oLAhPUY&brand=0&mls=1&
MlsNumber: T3519346


Listing Provided By: FUTURE HOME REALTY INC, original listing
Name: FUTURE HOME REALTY INC
Phone: (813) 855-4982
Office Name: FUTURE HOME REALTY INC
Office Phone: (813) 855-4982
Agent Name: Richard Mastykarz, PA
Disclaimer: Copyright © 2024 Pinellas Suncoast Association of REALTORS ®, Inc. 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 = 3239 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 Bambi Norman
Bambi Norman
ASCIIR A Wilkes Real Estate LLC
Call Today!: (315) 225-5181

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App