Sold on 02/28/24
Price Unknown
1575 Frankel Ave, Zachary, LA 70791
4beds
1,683sqft
Single Family Residence, Residential
Built in 2023
7,405.2 Square Feet Lot
$287,500 Zestimate®
$--/sqft
$2,081 Estimated rent
Home value
$287,500
$273,000 - $302,000
$2,081/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Estimated completion: 03/15/2024 Welcome to the newest addition to Zachary, LA, Cheval Trails. The Alvarez Construction exclusive community features homes ranging from 1,547 sq ft to 1,968 sq ft, perfect for any family. With these homes come many modern amenities, including a doorbell camera for added security. All homes come with a WiFi-enabled SmartHome management hub that includes 3 months of free monitoring. All homes also have a wireless smoke/heat combination detector and a WiFi-enabled thermostat with moisture controls and an advanced filtration system. With all of these smart home features, this community is sure to be the perfect place to call home. The Cambridge is a single-story, 1,683 sq ft, 4 bedroom 2 bathroom plan that features an open living area with 10’ ceilings. The kitchen features a large island and is open to the living room and the dining room. The large owner’s suite has windows to the backyard, an ensuite attached bath with double vanities, a walk-in shower, a separate garden tub, WC, and a spacious walk-in closet. Bedrooms 3 and 4 are located at the front of the home, and bedroom 2 is located off of the living room to offer a more private feel. Bathroom 2 is located in the same hallway as the utility room and bedroom 3. There is a 2-car garage that enters into the hallway with the utility room. All homes include a WiFi-enabled SmartHome management hub with a wireless security system, a wireless smoke/heat combination detector, and a WiFi-enabled thermostat. Included upgrades: electrical floor outlet in the living room, 3cm granite level 3 countertops throughout, custom tile shower in the owner's bathroom, fireplace tile level 4, tile level 2 in all wet areas, vinyl flooring in all common areas and bedrooms, kitchen wall cabinets to ceiling, kitchen trash can pull out drawer with 2 bins, cabinet hardware upgrade level 1, wood framed mirrors in all bathrooms & a single compartment kitchen sink.
Zillow last checked: 8 hours ago
Listing updated: March 04, 2024 at 12:44pm
Listed by:
Carlos Alvarez,
RE/MAX Total
Bought with:
Rory Breland, 0995684709
Blackstone Partners LLC
Source: ROAM MLS,MLS#: 2023015845
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Features: Ceiling 9ft Plus, Ceiling Fan(s), Walk-In Closet(s)
- Level: First
- Area: 224
- Dimensions: 14 x 16
Bedroom 1
- Level: First
- Area: 121
- Dimensions: 11 x 11
Bedroom 2
- Level: First
- Area: 121
- Dimensions: 11 x 11
Bedroom 3
- Level: First
- Area: 134.64
- Width: 12.33
Primary bathroom
- Features: Double Vanity, Separate Shower, Walk-In Closet(s), Soaking Tub, Water Closet
Dining room
- Level: First
- Area: 132.75
- Width: 9
Kitchen
- Features: Granite Counters, Counters Solid Surface, Stone Counters, Kitchen Island, Pantry
- Level: First
- Area: 170
- Width: 15
Living room
- Level: First
- Area: 282.5
- Length: 15
Heating
- Central, Gas Heat
Cooling
- Central Air, Ceiling Fan(s)
Appliances
- Included: Elec Stove Con, Gas Stove Con, Gas Cooktop, Dishwasher, Disposal, Microwave, Oven, Gas Water Heater
- Laundry: Electric Dryer Hookup, Washer Hookup
Features
- Ceiling 9'+, Ceiling Varied Heights, Crown Molding
- Flooring: Carpet, Ceramic Tile, Laminate, Wood
- Attic: Attic Access
- Number of fireplaces: 1
- Fireplace features: Gas Log, Ventless
Interior area
- Total structure area: 2,271
- Total interior livable area: 1,683 sqft
Property
Parking
- Total spaces: 2
- Parking features: 2 Cars Park, Garage, Garage Door Opener
- Has garage: Yes
Features
- Stories: 1
- Patio & porch: Porch, Patio
- Exterior features: Lighting
- Fencing: None
Lot
- Size: 7,405 sqft
- Dimensions: 60 x 125
- Features: Landscaped
Details
- Parcel number: 30852983
- Special conditions: Owner/Agent
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cottage
- Property subtype: Single Family Residence, Residential
Materials
- Brick Siding, Fiber Cement, Stucco Siding, Frame
- Foundation: Slab
- Roof: Shingle
Condition
- New construction: Yes
- Year built: 2023
Details
- Builder name: Alvarez Construction Co., Inc.
- Warranty included: Yes
Utilities & green energy
- Gas: Entergy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected
Community & neighborhood
Security
- Security features: Security System, Smoke Detector(s)
Community
- Community features: Park
Location
- Region: Zachary
- Subdivision: Cheval Trails
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $648 annually
- Services included: Common Areas, Maintenance Grounds, Insurance, Legal, Management
Other
Other facts
- Listing terms: Cash,Conventional,FHA,VA Loan
Price history
| Date | Event | Price |
|---|---|---|
| 5/9/2024 | Listing removed | -- |
Source: Zillow Rentals | ||
| 3/2/2024 | Listed for rent | $2,225$1/sqft |
Source: Zillow Rentals | ||
| 2/28/2024 | Sold | -- |
Source: | ||
| 1/24/2024 | Pending sale | $299,990$178/sqft |
Source: | ||
| 9/21/2023 | Listed for sale | $299,990$178/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $455 +606.2% | $3,500 +600% |
| 2023 | $64 | $500 |
Find assessor info on the county website
Neighborhood: 70791
Nearby schools
GreatSchools rating
- 7/10Copper Mill Elementary SchoolGrades: 5-6Distance: 0.6 mi
- 7/10Northwestern Middle SchoolGrades: 7-8Distance: 2.8 mi
- 6/10Zachary High SchoolGrades: 9-12Distance: 2.4 mi
Schools provided by the listing agent
- District: Zachary Community
Source: ROAM MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

