Price Adjustment! Time To Go! Rare Find Nestled in the desirable Pines of Greenleaves Subdivision. This recently renovated home boasts Brilliant Colors & Fantastic Architecture for a Stunning Space. Just right for your growing family & friends to enjoy with an open floor plan, a huge adjoined Living/Great room with beautiful views overlooking the pool, a Chef's kitchen, 4 bedrooms, 3 full baths, 2 half baths, a Private Office, Game room, Media Room, Wellness room, full bar & poker room. Close access to shops, Restaurants & the Causeway.
Closed
Price Unknown
2015 Scotchpine Ln, Mandeville, LA 70448
4beds
5,450sqft
Single Family Residence
Built in 2007
0.35 Acres Lot
$847,900 Zestimate®
$--/sqft
$4,557 Estimated rent
Owner options
What's special
Zillow last checked: 7 hours ago
Listing updated: July 27, 2023 at 10:53am
Listed by:
JOHN CERNIGLIA 504-957-6857,
PREMIER PROPERTIES NORTHSHORE
Bought with:
Elizabeth Hernandez
NOLA Living Realty
Source: GSREIN,MLS#: 2383487
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 3
- 1/2 bathrooms: 2
Primary bedroom
- Description: Flooring: Wood
- Level: Lower
- Dimensions: 13.8000 x 19.6000
Bedroom
- Description: Flooring: Wood
- Level: Upper
- Dimensions: 13.7000 x 19.9000
Bedroom
- Description: Flooring: Wood
- Level: Upper
- Dimensions: 12.5000 x 11.4000
Bedroom
- Description: Flooring: Wood
- Level: Upper
- Dimensions: 12.0000 x 12.0000
Game room
- Description: Flooring: Wood
- Level: Upper
- Dimensions: 24.0000 x 22.0000
Kitchen
- Description: Flooring: Tile
- Level: Lower
- Dimensions: 12.0000 x 40.1000
Living room
- Description: Flooring: Wood
- Level: Lower
- Dimensions: 24.5000 x 52.8000
Media room
- Description: Flooring: Carpet
- Level: Upper
- Dimensions: 14.9000 x 21.8000
Heating
- Central, Multiple Heating Units
Cooling
- Central Air, 3+ Units, Attic Fan
Appliances
- Included: ENERGY STAR Qualified Appliances
Features
- Ceiling Fan(s), Carbon Monoxide Detector, Granite Counters, Vaulted Ceiling(s)
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 6,202
- Total interior livable area: 5,450 sqft
Property
Parking
- Parking features: Attached, Garage, Two Spaces, Garage Door Opener
- Has garage: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Pavers, Patio
- Exterior features: Fence, Outdoor Shower, Patio, Outdoor Kitchen
- Pool features: Heated, In Ground
Lot
- Size: 0.35 Acres
- Dimensions: 87 x 138 x 120 x 121
- Features: Corner Lot, Irregular Lot, Outside City Limits
Details
- Additional structures: Cabana
- Parcel number: 47005
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: French Provincial
- Property subtype: Single Family Residence
Materials
- Brick, Frame, Stucco
- Foundation: Slab
- Roof: Asphalt,Shingle
Condition
- Excellent,Updated/Remodeled,Resale
- New construction: No
- Year built: 2007
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Green energy
- Energy efficient items: Appliances, HVAC, Insulation, Lighting, Water Heater
Community & neighborhood
Security
- Security features: Smoke Detector(s)
Location
- Region: Mandeville
- Subdivision: Greenleaves Pines
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $148 quarterly
Sell for more
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$847,900
2% more+$16,958
With Zillow Showcase(estimated)$864,858