38404 Queen St

Description
- Listed by Saun A Sullivan • Cicero Realty, LLCP: (225)-369-6111 C: (225)-369-6111 INFO6@DSLDNEWHOMES.COM
Property Details for 38404 Queen Street
Property Details for 38404 Queen Street
| Status | Closed |
|---|---|
| MLS # | BR2024004708 |
| Days on Market | 1 |
| Taxes | - |
| HOA Fees | $380 / year |
| Condo/Co-op Fees | - |
| Compass Type | Single Family |
| MLS Type | Residential / Detached Single Family |
| Year Built | 2024 |
| Lot Size | 0.18 AC / 8,058 SF |
| County | Ascension Parish |
Location
Sold By Pivot Realty
Building Information for 38404 Queen Street
Payment Calculator
$1,979 per month
30 year fixed, 6.11% Interest
$1,663
$285
$32
Property Information for 38404 Queen Street
- Directions: From I-10 E: Exit 166 for Highland Rd (LA-42) Left at the light - go under the interstate on Highland Rd Continue down Highland Rd ~5 miles Right on Airline Hwy (US-61 S) Stay on Airline Hwy ~6 miles Left on LA-42 E Windsor Park will be on Right ~1/2 mile
- Latitude: 30.32
- Longitude: -90.96
- MLS Area Minor: ASCENSION
- Year Built: 2,024
- Local Area: ASC MLS Area 90
- Parking Features: Attached, Concrete, Garage
- Garage Sq Ft: 429
- School District: Ascension Parish
- High School: Ascension Parish
- Elementary School: Ascension Parish
- Middle School: Ascension Parish
- Association Amenities: Subd Sidewalk
- Association Fee: $380.00
- Association Fee Frequency: Annually
- Association Fee Includes: Management HOA
- Association: Yes
- Tax Legal Description: Windsor Park Subdivision: Sect. 25, T-8S, R-2E, Southeastern Land District, East of the Mississippi River, Ascension Parish, LA
- Tax Lot: 7
- Above Grade Finished Area: 2141.0
- Building Area Total: 2784.0
- Living Area: 2141.0
- Living Area Source: Estimated
- Lot Features: Level
- Lot Size Acres: 0.185
- Lot Size Dimensions: 62x130
- Cvrd Porch Sq Ft: 48
- Home Warranty: Yes
- Parcel Number: TBD
- Property Sub Type: Detached Single Family
- Property Type: Residential
- Mineral Rights: Conveyed
- Apx Age: *New 3-Complete
- Overall Condition: New
- Sewer: Public Sewer
- Water Source: Public
- GS Utilities Gas: Atmos
- Construction Materials: Brick, Frame, Stucco
- Exterior Features: Landscaped, Lighting
- Foundation Details: Slab: Post Tension
- Patio And Porch Features: Patio: Concrete, Covered
- Pool Private: No
- Roof: Shingle
- Stories: 1
- Appliances: Disposal, Dishwasher, Microwave, Range
- Bathrooms Full: 2
- Bedrooms Total: 3
- Cooling: Central Air
- Fireplace Features: 1 Fireplace, Gas Log, Ventless
- Flooring: Carpet, Ceramic Tile
- Heating: Central, Natural Gas
- Interior Features: Attic Access, High Speed Internet, Ceiling Fan(s), Inside Laundry
- Laundry Features: Washer/Dryer Hookups
- Other Equipment: Garage Door Opener, Smoke Detector
- Room Type: Breakfast Room/Nook, Bonus Room, Bedrm: Additional, Master Bedroom, Bath: Full, Master Bathroom, Dining Room, Garage, Great Room, Keeping, Kitchen, Laundry, Office, Pantry, Other
- Bathrooms Display: 2/
- Builder Model: BIRCH III A
- Builder Name: DSLD, LLC
- BA Master Bath: MBA 2+ Closets,MBA Double Vanity,MBA Separate Shower,MBA Tub: Garden/Soaking,MBA Walk-In Closets
- BD Master Bedroom: MBR Ceiling Fan,MBR En Suite Bath
- RO Room Types Level 1: Breakfast Room/Nook (L1),Bonus (L1),Bedrm: Additional (L1),Bedrm: Master (L1),Bath: Full (L1),Bath: Master (L1),Dining Room Formal (L1),Garage (L1),Greatroom (L1),Keeping (L1),Kitchen (L1),Laundry (L1),Office/Study (L1),Pantry (L1),Other (L1)
- KF Kitchen Features: Island
Property History for 38404 Queen Street
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Jul 15, 2025 | Permanently Off Market ROAM MLS #BR2025011593 | $359,900 | — |
| Jun 20, 2025 | Listed (Active) ROAM MLS #BR2025011593 | $359,900 | — |
| May 13, 2024 | Sold (Public Record) Public Record #1532051892 | — | |
| May 13, 2024 | Sold ROAM MLS #BR2024004708 | — | |
| Mar 21, 2024 | Contract Signed ROAM MLS #BR2024004708 | — | |
| Mar 21, 2024 | Listed (Active) ROAM MLS #BR2024004708 | $342,580 | — |
| Date | Event & Source | Price |
|---|---|---|
| 07/15/2025 | Permanently Off Market ROAM MLS #BR2025011593 | $359,900 |
| 06/20/2025 | Listed (Active) ROAM MLS #BR2025011593 | $359,900 |
| 05/13/2024 | Sold (Public Record) Public Record #1532051892 | — |
| 05/13/2024 | Sold ROAM MLS #BR2024004708 | — |
| 03/21/2024 | Contract Signed ROAM MLS #BR2024004708 | — |
| 03/21/2024 | Listed (Active) ROAM MLS #BR2024004708 | $342,580 |
For completeness, Compass often displays two records for one sale: the MLS record and the public record.
Public Records for 38404 Queen Street
Schools near 38404 Queen Street
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 5 | |||
| Public - | 6 to 8 |
Rating | School | Distance |
|---|---|---|
Prairieville Primary School PublicPK to 5 | ||
Prairieville Middle School Public6 to 8 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Similar Sold Homes
Explore Nearby Homes
- Autumn View Homes for Sale
- Autumn Woods Homes for Sale
- Bluff Heritage Homes for Sale
- Crestview Estates Homes for Sale
- Manchac Commons Homes for Sale
- Manchac Place Homes for Sale
- Maplewood Estates Homes for Sale
- Old Perkins Place Homes for Sale
- Parisienne Villas Homes for Sale
- Santa Maria Homes for Sale
- Shadows of Ascension Homes for Sale
- Southeast Baton Rouge Homes for Sale
- Southwood Village Homes for Sale
- Stone Ridge Homes for Sale
- The Hollows of Dutchtown Homes for Sale
- St. Gabriel Homes for Sale
- Prairieville Homes for Sale
- French Settlement Homes for Sale
- Geismar Homes for Sale
- Carville Homes for Sale
- Gonzales Homes for Sale
- Baton Rouge Homes for Sale
- Sorrento Homes for Sale
- Sunshine Homes for Sale
- Denham Springs Homes for Sale
- Walker Homes for Sale
- Holden Homes for Sale
- White Castle Homes for Sale
- Darrow Homes for Sale
- St. Amant Homes for Sale
- 70776 Homes for Sale
- 70817 Homes for Sale
- 70810 Homes for Sale
- 70809 Homes for Sale
- 70726 Homes for Sale
- 70733 Homes for Sale
- 70734 Homes for Sale
- 70737 Homes for Sale
- 70774 Homes for Sale
- 70721 Homes for Sale
- 70754 Homes for Sale
- 70449 Homes for Sale
- 70346 Homes for Sale
- 70788 Homes for Sale
- 70816 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Cicero Realty, LLC
The data relating to real estate listings on this website comes in part from the Internet Data Exchange (IDX) program of Multiple Listing Service of ROAM MLS, Gulf Coast Association of REALTORS, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listings provided by brokerages other than Compass are identified with the ROAM MLS, Gulf Coast Association of REALTORS, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS Logos. All Information Is Deemed Reliable But Is Not Guaranteed Accurate. All information should be verified by the recipient and none is guaranteed as accurate by ROAM MLS, Gulf Coast, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS.Listing information Copyright© 2026 MLS of ROAM, Gulf Coast, REALTOR Association of Acadiana and South West Louisiana Multiple Listing Service, Inc. All Rights Reserved.


1