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

6704 N Harer Street
Tampa, FL 33604

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $574,999
Beds: 3
Baths: 3
Status: Active
SqFt: 2266
Agency: Compass

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: ***PRICE IMPROVEMENT TO $574,999*** Your brand new construction home in Seminole Heights has JUST BEEN COMPLETED! Pulling up to this handsome home, the curb appeal does not disappoint. Crafted in a Modern Farmhouse style with an expansive front porch, the home is set amidst green grass and lush landscaping. The porte cochere is an elegant touch, ready for you to park and head inside. Once inside, you will notice the numerous windows and abundance of natural light. The open floor plan is perfect for gatherings. You have space for two separate living areas AND room for dining. You also have a spacious office with a closet for keeping work or play tidy, an attractive half-bathroom and tons of storage. Luxury Vinyl Plank flooring flows throughout the first floor as well as upstairs (no carpet in your bedrooms)! The high ceilings, with attractive recessed lighting, classic elegant hardware, wood trim, and crown molding, along with the overall light neutral palette, lend themselves to any design style you prefer. The kitchen is the true star of the show! It is a chef's dream with custom solid wood soft-close cabinetry, top of the line Samsung Stainless Steel appliances, as well as an expansive island with storage and gleaming countertops of high-end veined quartzite. Your new kitchen features an impressively sized walk-in pantry with room for all of your appliances and accessories. Everywhere you look, you can tell this home was built with the discerning owner in mind. Head upstairs, by way of the gorgeous hardwood staircase, to your area made for relaxation. Two large guest bedrooms with walk-in closets sit to one side of the home, while your luxurious owner's suite is on the other. You will love this serene room with a large walk-in closet and lavish en-suite bathroom. Here you will find a beautifully tiled walk in shower with a custom glass-enclosed shower, hexagon marble mosaic on the floor and subway tiles on the walls. You have more of the gorgeous quartzite for countertops, solid wood soft-close cabinets, dual sinks, and a private water closet as well. Your second floor also includes an amply sized laundry room, the lovely guest bathroom, and a nook perfect for a small desk or, as we envisioned it, a cozy seating area. If you are ready for some sunshine, head back downstairs where you have a covered back patio and tropical backyard. Other fantastic items to note: dual-zoned HVAC, Low E impact windows/doors, upgraded electric with Rheem tankless water heater, plus the builder supplies a Standard 2-10 structural warranty along with any warranties pertaining to appliances. Durability, energy efficiency, and peace of mind are ensured for years to come. This new home is set in Old Seminole Heights allowing you proximity to a variety of great dining and shopping options. Close favorites are Ellas, Rolling Mullet, and Magnanimous Brewing. Plus, you are a quick trip to downtown Tampa, Ybor City, and the Tampa International Airport. You can't go wrong purchasing this beauty! Make your appointment today for a private tour to make this your home tomorrow!
MlsNumber: T3519400


Listing Provided By: Compass, original listing
Name: Compass
Phone: (551) 404-5204
Office Name: COMPASS FLORIDA, LLC
Office Phone: (813) 355-0744
Agent Name: Cristy Holt
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 = 3204 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 Daniel Ramize
Daniel Ramize
ASCIILuxury Real Estate Group
Call Today!: (813) 992-9816

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App