Meet our Sterlington plan. Smart home automation is included in this open 4 bed 2 bath single story home. Enjoy cooking and entertaining in the upgraded beautiful kitchen that boast KitchenAid stainless steel appliances including gas range, dishwasher, microwave, 3cm slab granite, undermount sink, subway tile backsplash, pull down kitchen faucet as well as large walk-in pantry. This beautiful kitchen is open to the large living room with cozy fireplace. The master suite will not disappoint with its abundant walk-in closet, oversized soaking tub, separate shower dual vanities. The Sterlington has storage galore linen closet, coat closet, oversized laundry and walk-in bedroom closets. Exterior amenities include a covered rear patio, 6 ft wood privacy fence, 2 car garage, fully sodded yard and tastefully landscaped front yard. Move-in ready August 2020. This beautiful home is located in Prairieville's newest exclusive community, Germany Oaks Phase 2. Upon entering our community you will be taken away with the majestic Live Oak Trees, lush green space, private lake and a playground area for the kids. This community is a development that provides a safe haven for homeowners. Only 76 beautiful homes will grace Germany Oaks Phase 2.
Single-familyProperty Type
2022Year Built
9,147 sq ftLot Size
$110Est. Price/Sq.Ft.
1 garage spacesParking
Listed by • Keller Williams Realty-First Choice
Bought with NON-MEMBER LICENSEE• NON-MEMBER OFFICE
Meet our Sterlington plan. Smart home automation is included in this open 4 bed 2 bath single story home. Enjoy cooking and entertaining in the upgraded beautiful kitchen that boast KitchenAid stainless steel appliances including gas range, dishwasher, microwave, 3cm slab granite, undermount sink, subway tile backsplash, pull down kitchen faucet as well as large walk-in pantry. This beautiful kitchen is open to the large living room with cozy fireplace. The master suite will not disappoint with its abundant walk-in closet, oversized soaking tub, separate shower dual vanities. The Sterlington has storage galore linen closet, coat closet, oversized laundry and walk-in bedroom closets. Post-tension slab with 10 year structural warranty and Smart Home automation included; Qolsys panel, WiFi thermostat, WiFi enabled deadbolt lock, garage door opener, doorbell camera, and Alexa Dot for voice control - or you can control from your smart phone. Celebrate the return of neighborhood living with your family in Lakeshore Villages! Swim in the resort style, community pool and splash pad, picnic under the shade of the open-air pavilion, or let the kids run and play at the neighborhood playground. Get your work out in at our Fitness Center inside the Clubhouse. Visit the neighborhood lakes and enjoy fishing or relaxing in the sun by the fountains. We also have a Basketball Court, Soccer Field, Fishing Pier, and Dog Parks in our community!
Year
Property tax
Land + Additions
Assessment*
2025
$4,524 (−1.2%)
$3,000 + $27,056
$30,056
2024
$4,578 (+19.7%)
$3,000 + $27,056
$30,056
2023
$3,826
$3,000 + $20,483
$23,483
Tax history for 3878 Hummel Crest Rd
Year
Property tax
Land + Additions
Assessment*
2025
$4,524 (−1.2%)
$3,000 + $27,056
$30,056
2024
$4,578 (+19.7%)
$3,000 + $27,056
$30,056
2023
$3,826
$3,000 + $20,483
$23,483
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
7,442 Sq. Ft.
Year renovated
—
Sq. Ft.
2,346
Year built
2022
Style
Single Family Residential
County
St. Tammany Parish
APN
136392
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 29, 2026.
PUD
Planned Unit Development District.
A planned unit development or PUD describes a zoning designation and a process whereby limited deviation from the standards of this UDC is permitted to provide flexibility to accommodate innovative, high-quality site and building design that is otherwise not possible through the application of existing standards prescribed in the UDC. PUD applications shall be reviewed according to the procedures outlined in Chapter 200, Sec. 200-3.12. To be eligible to submit an application for a PUD zoning district map amendment, a proposed development must: Contain a mix of residential and commercial uses, where uses customarily permitted inresidential areas such as golf or community clubs or recreational areas do not qualify as a commercial use meeting this requirement; and Must include the following approaches in innovative land use planning: Environmentally sensitive design that includes preservation of existing natural features of a site that is of a higher quality than would be possible under the regulations otherwise applicable to the property that reduces the risk of flood damage to life and property and enhances drainage functions.; Diversification and variation in the relationship of residential uses, open space, setbacks, and the height of structures compatible with surrounding neighborhoods, which creates a variety of housing types, environments and living units characterized by a cohesive building, sign, and site development program. Minor changes to setbacks or lot width are not considered a variety of housing types; see Ch. 100 definition of housing types for more information.
Property details
Parking
Parking/Garage Information
# of Parking Spaces Total: 2
Has Garage
Parking Features: Garage, Garage Door Opener
Interior
Bathroom Information
# of Full Bathrooms: 2
Heating & Cooling
Has Cooling
Cooling: Central Air, Ceiling Fan(s)
Has Heating
Heating: Central
Interior Features
Interior Features: High Ceilings
Appliances: Range, Oven, Dishwasher, Disposal
Flooring: Tile, Carpet, Ceramic Tile, Laminate
Room Information
Laundry Features: Electric Dryer Hookup, Washer Hookup, Inside
Exterior
Exterior Features
Patio And Porch Features: Patio, Covered
Fencing: None
Roof: Shingle
Mobile Home Information
Model: Sterlington Eb
Building Information
# of Stories Total: 1
Builder Name: D.r. Horton, Inc. - Gulf Coast
Construction Materials: Frame, Brick
Has Home Warranty
Foundation Details: Slab
Property Features
New Construction
Security Features: Smoke Detector(s)
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Detached Single Family
Property Condition: New Construction
Possible Use: Residential
Land Information
Topography: Level
Lot Information
Lot Features: Level
Lot Size Dimensions: 76 x 120
Lot Size Area: 9,147.6
Lot Size Acres: 0.21
Utilities
Utility Information
Water Source: Public
Sewer: Public Sewer
Location
HOA Information
Has Homeowners Association
Association Amenities: Maintenance, Management, Pool
Association Fee: $1,125
Association Fee Includes: Insurance
Schools Information
Elementary School District: St Tammany Parish
Middle Or Junior School District: St Tammany Parish
High School District: St Tammany Parish
Location Information
Directions: Take I 10 and exit Oak Harbor Lakeshore, then take the round a bout to the I-10 Service Road. Go through the Blue Towers, past the fountain, over the levee, and the Sales Office is on the right side.
Subdivision Name: Lakeshore Villages
Community Information
Community Features: Clubhouse, Playground, Pool
Public facts
Beds: —
Baths: —
Sq. Ft.: 2,346
Stories: —
Lot Size: 7,442 square feet
Style: Single Family Residential
Year Built: 2022
Year Renovated: —
County: St. Tammany Parish
APN: 136392
Home facts updated by county records on Jun 29, 2026
Around this home
Schools
Abney Elementary Early Childhood Center
Public PreK-K • Assigned • 2.3mi
St. Tammany Junior High School
Public 6-8 • Assigned • 3.0mi
3/10
Salmen High School
Public 9-12 • Assigned • 2.1mi
3/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Historical weather
Slidell, LA • 70461
Average low and high temperatures (°F)
61
42
69
50
75
57
80
63
84
69
90
75
92
76
90
75
88
72
83
63
75
57
66
47
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.8 hours in
June and 5.2 hours in December, which is comparable to the
U.S. average for solar exposure.
8.8 hrs
5.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$302,000 – $366,000
Reach more buyers when you sell with Redfin. Save up to $3,178 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.