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

125 Sitka Loop
Haughton, LA 71037

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2196 Square Feet
Agency: Diamond Realty & Associates
Agency Phone: (318) 746-0011

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Garbage Disposer, Oven - Gas, Cooktop - Gas
Architectural Style: Other
Construction Materials: Brick
Flooring: Carpet, Tile, Tile - Ceramic
Heating: Central Furnace, Fireplace
Interior Features: Kitchen Island, Pantry, Walk-in Closet(s), Vaulted Ceiling(s), Open Floorplan, Granite Counters, High Speed Internet Available, Decorative Lighting
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: Fence, Covered Patio/Porch
Fencing: Fenced
Parking Features: Garage
Patio and Porch Features: Patio, Porch
Property Condition: New Construction
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Bossier ISD schools
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Pin Oak Landing

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: NEW CONSTRUCTION IN HAUGHTON! Welcome to 125 Sitka Loop, a beautiful home located in Pin Oak Landing! Featuring 4 bedrooms, 3 baths and over 2,100 sq ft. Open floor plan with so many custom touches throughout. Spacious kitchen and living area, perfect for entertaining family and friends! Kitchen boasts granite counter tops, painted cabinetry, gas cook top with separate oven, large island and a walk in pantry! Cozy living area with a fireplace, cabinet storage and wooden accents! Remote master bedroom with an en-suite bathroom. Master bath has dual sinks, large soaking tub, walk in tiled shower and a large walk in closet! Laundry room is connected to the master closet and also offers TONS of space and storage. The other three bedrooms also have their own bathroom! 2 car garage! Backyard will be fully fenced in with a wooden privacy fence, covered patio and it is plumbed for an outdoor kitchen. Convenient location and amazing schools! This subdivision has sidewalks and a beautiful pond!
MlsNumber: --
ListingId: 20509915


Listing Provided By: Diamond Realty & Associates, original listing
Phone: (318) 518-6447
Office Phone: (318) 746-0011
Agent Name: Sarah McCoy
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App