Title Page Background
DEBUG FN args: Array ( [0] => 3233 [1] => [2] => [3] => agent ) BEFORE: Site: 3233 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3233 Igate: njhud LocID: 3233 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 = 3233 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3233 [1] => [2] => [3] => lender ) BEFORE: Site: 3233 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3233 Igate: njhud LocID: 3233 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 = 3233 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3233 [1] => [2] => [3] => other ) BEFORE: Site: 3233 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3233 Igate: njhud LocID: 3233 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 = 3233 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

32245 Mahogany Valley Drive
Wesley Chapel, FL 33543

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $951,900
Beds: 4
Baths: Full: 4
Status: Pending
SqFt: 4024 Square Feet
Agency: BHHS FLORIDA PROPERTIES GROUP

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer
Architectural Style: Other
Construction Materials: Stone, Stucco, Block
Flooring: Carpet, Tile
Heating: Central Furnace, Heat Pump
Interior Features: Solid Surface Counters, Walk-in Closet(s), Open Floorplan, PRIMARY BEDROOM MAIN FLOOR, COFFERED CEILING(S), NINGUNO
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Kitchen, Great Room, Loft, Game Room

Window Features

Exterior Features: Irrigation System, Sliding Doors, Sidewalk
Parking Features: Garage, Garage - Attached
Property Condition: New Construction
Roof: Tile, Concrete

Neighborhood/Schools

Elementary School/District: Double Branch Elementary
Middle/Junior High School/District:
High School/District: Wesley Chapel High-PO
Subvidision Name: Winding Ridge

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Under Construction. No Lottery and No Waiting Lists to build a coveted Carson model in the sold out community of Winding Ridge by GL Homes in Wesley Chapel. If you wanted to live on model row this is your chance! This unbelievable opportunity will not last! The finest attention to detail has been considered in the designing of this open floor plan dramatic home! The Primary suite is on the main floor with a grand living room and dining room plus a great room open to a gourmet kitchen and another bedroom for guests or family.. On the second floor you have two additional bedrooms, a huge game room that you can use as a media room or whatever suits your needs. Additionally, there is a loft as well along with two large bedrooms. The Carson is one of the most popular floor plans by GL because of the dramatic two story entrance and wrap around staircase. You have a lot of room to entertain in this beautiful home. When you chose to live in Winding Ridge you are choosing not just a home but a luxury resort lifestyle. No CDD and your HOA fee covers all of your landscaping so you have more time to enjoy the fabulous clubhouse, pools, tennis and pickle ball courts, playgrounds and all of the activities planned for you by the lifestyle director. Don't miss out!
MlsNumber: --


Listing Provided By: BHHS FLORIDA PROPERTIES GROUP, original listing
Phone: (845) 729-0573
Office Phone: (813) 907-8200
Agent Name: Keriann Rodriguez
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => pasco-county-southeast [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: pasco-county-southeast State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: pasco-county-southeast State: FL 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 = 3233 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Nicole 'Nikki' Musgrave, Managing Broker
Nicole 'Nikki' Musgrave, Managing Broker
Engel & Völkers Trinity
Call Today!: (863) 224-5090

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App