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

Tbd Burnett Boulevard
Alvarado, TX 76009
Jamie Wickliffe with CENTURY 21 Judge Fite Company, original listing - (972) 723-8231

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,292,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 2658 Square Feet
Agency: CENTURY 21 Judge Fite Company
Agency Phone: (972) 723-8231

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Investor Alert! Prime Duplex Opportunity with Expansion Potential! This brand-new duplex offers an exceptional opportunity to own a modern, stylish property with room to grow. Each side of the duplex features 3 bedrooms, 2 bathrooms, and a 1-car garage, perfectly blending functionality with contemporary design. Thoughtfully crafted with durable, stained concrete flooring throughout, the home is both elegant and easy to maintain—ideal for tenants or homeowners seeking low-maintenance living.<br /> <br /> The kitchens are a standout, boasting sleek granite countertops, a modern aesthetic, and generous pantries with floating shelves that offer both storage and flair. All essential appliances will be installed prior to move-in, and the home is already wired for an alarm system, offering added peace of mind once electricity is connected. The open-concept layout provides a spacious, inviting atmosphere, making it perfect for families or renters alike. Each unit also features a private, fenced backyard—ideal for pets, entertaining, or relaxing outdoors.<br /> <br /> Adding even greater value to this offering are four adjacent lots—located at 1012, 1016, 1020, 1024, and 1028 Burnett Blvd—creating a combined total of 1.973 acres. These parcels, along with the duplex at 1020 Burnett Blvd, offer significant potential for expansion, development, or long-term investment. Lot sizes include: 1012 Burnett at 0.31 acres, 1016 Burnett at 0.34 acres, 1020 Burnett with the duplex at 0.48 acres, 1024 Burnett at 0.49 acres, and 1028 Burnett at 0.35 acres.<br /> <br /> Whether you're looking to generate immediate rental income or explore future development possibilities, this move-in-ready duplex combined with expansive land provides a rare and valuable opportunity. Schedule your private showing today and discover everything this property has to offer!
MlsNumber: --
ListingId: 20917724


Listing Provided By: CENTURY 21 Judge Fite Company, original listing
Phone: (972) 723-8231
Office Phone: (972) 723-8231
Agent Name: Jamie Wickliffe
Disclaimer: Copyright © 2025 North Texas Real Estate Information Systems, 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 = 2647 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;
Rebekah Bailey
ASCIICentury 21 Mike Bowman
Call Today!: (817) 357-7809

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App