Title Page Background
DEBUG FN args: Array ( [0] => 350 [1] => [2] => [3] => agent ) BEFORE: Site: 350 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 350 Igate: njhud LocID: 350 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 350 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 350 [1] => [2] => [3] => lender ) BEFORE: Site: 350 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 350 Igate: njhud LocID: 350 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 350 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 350 [1] => [2] => [3] => other ) BEFORE: Site: 350 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 350 Igate: njhud LocID: 350 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 350 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

7376 Fall Street
Brooksville, FL 34613
Kimberly Pye, PA with HOME LAND REAL ESTATE INC, original listing - (352) 556-0909

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3300 Square Feet
Agency: HOME LAND REAL ESTATE INC
Agency Phone: (352) 556-0909

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: INCREDIBLE...THIS ONE HAS IT ALL!! ALMOST NEW 2024 Dream Custom Home with amazing outdoor living space - built by the builder as his custom home with all the upgrades!! 5 bedrooms (or 4 with office) + 3 full bathrooms + 4 car garage with 9,000 lb lift and 8' tall garage doors (18' and 14' wide) for your larger vehicles + private pool with sun shelf and safety fence + completely fenced + nestled in the trees with paved driveway on 1.24 acres yet minutes to the Suncoast Parkway near Hwy 50/Cortez + NO FLOOD + NO HOA + remaining Builder's Warranty!! Craftsman style home with board and batten, and stone on the exterior and all the newest sleek modern country finishes on the inside! 3,300 sq ft living space; 5,221 square feet total under roof!! High 10' ceilings throughout the home! Tray ceilings in every room! Large glass sliders and windows with the high ceilings and open floor plan make the home feel light, bright, and very spacious! STUNNING upgraded kitchen with all gorgeous Quartz countertops (this kitchen is truly the focal point of this home and open to the large family room and dining area), gorgeous real wood shaker cabinets, built-in table, upgraded stainless steel appliances with built-in oven, cooktop, range hood!! Check out this ENORMOUS pantry!! Walk into the grand entrance of the home and enter the double doors into the impressive foyer and formal living room with expansive glass sliders that look out over the lanai and private pool - it's impressive just walking in!! The EXTRA large master suite will lure you into your own private retreat - with a spa-like ensuite master bathroom with 13' ceilings + a walk-in closet as large as a bedroom + huge shower with frameless glass, multiple shower heads and rain forrest shower head + soaking tub + dual sinks + Quartz countertops! 2nd and 3rd bathrooms have matching upgraded finishes and the 3rd bathrooms doubles as a pool bath!! The glass sliders pocket so you can open up the large family rooms to the covered lanai and pool area making this an incredible outdoor living space!! The family room boasts a stacked stone fireplace that brings the outdoors indoors and helps easily warm the room with an ambiance of a fireplace (easy and no mess electric fireplace). Zoned R1C. NO HOA...so bring your boat, RV/camper, ATVs or side-by-side, pets!! Located close to everything...the Suncoast Parkway for quick and easy access to Tampa, the Brooksville Hospital (now Tampa General Hospital), restaurants, movies, shopping, Historic Downtown Brooksville. 10-15 minutes to kayaking the clear Weeki Wachee River with the manatees, fishing, boating, jetskiing, sunsets and the beach at Pine Island! The area has so much to offer!
MlsNumber: --
ListingId: W7870692


Listing Provided By: HOME LAND REAL ESTATE INC, original listing
Phone: (352) 279-1150
Office Phone: (352) 556-0909
Agent Name: Kimberly Pye, PA
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App