FBpixel

DEBUG INFO: 1

London Properties - The Most Trusted Name In Real Estate

Contact us directly - 436-4000

Fresno Bee People's Choice Award Winner - #1 Best Real Estate Company
Leading Real Estate Companies Of The World Award Winner - #1 Most Innovative Nationwide Broker
The Business Journal Award Winner - #1 Best Residential Real Estate Company
The Business Journal Award Winner - #1 Best Company To Work For
Fresno Bee People's Choice Award Winner - #1 Best Real Estate Company Leading Real Estate Companies Of The World Award Winner - #1 Most Innovative Nationwide Broker The Business Journal Award Winner - #1 Best Residential Real Estate Company The Business Journal Award Winner - #1 Best Company To Work For
Create Account

Fields marked with * are required.

However, providing more information will allow us to better serve your needs.

* First Name:

* Last Name:

* Email Address:

* Password:

* Confirm Password:

Street Address:

City:

State:

Zip:

Cell Phone:

Other Phone:

    

Login
Email:
Password:
    
Home
BUYING
SELLING
MOVING
AGENTS
Careers
CONTACT
ABOUT US
 Create Account |  Login  | View in Spanish 
Email:
Password:
    

Fields marked with * are required.

However, providing more information will allow us to better serve your needs.

* First Name:

* Last Name:

* Email Address:

* Password:

* Confirm Password:

Street Address:

City:

State:

Zip:

Cell Phone:

Other Phone:

 

    

2883 Ahlem, Turlock, CA 95382

Get More Info Or Schedule A Viewing

Email This Listing To A Friend

Print A Flyer

New Price, PREMIER LEGENDS LOCATION, Upgrades: Spacious Formal Dining/Living. Two Bay Window features offer an Abundance of Natural Light, Reflecting upon Impressive Grand Ceilings. GRANITE Counters, Kit OPEN to Separate Family Rm, GAS Fireplace Insert, HARDWOOD FLOORS, Berber Carpets in Bedrooms. MASTER SUITE; Relaxing Oval-JETTED-Tub, Dual Sink Vanity, 2 Closets. PRIVATE BACK YARD, Pergola & Covered Patio, Low Maintenance Landscaping. French Doors @ OFFICE/4th Bed. Inside Laundry plus Sink. Finished 3-CAR GARAGE, Central VAC, SOFT-WATER, Whole House Fan, ALARM, Electrical SUPPLY for Spa, NEW HVAC SYSTEM 2017. Super Clean Ready to Occupy. Schools nearby: Turlock Christian, Dutcher Middle, Dennis Earl.

Mortgage Calculator

Share: 
Mortgage Calculator
Down Payment (10%)
Total Purchase Price
Choose Your Rate
Loan Terms In Years
Estimated Payment
Mortgage Calculator Mortgage Calculator Mortgage Calculator

Get More Info Or Schedule A Viewing

2883 Ahlem, Turlock, CA 95382 Get More Info Get More Info

Please provide the following information and
one of our customer service representatives will assist you.

First Name:

Last Name:

Cell Phone:

Other Phone:

Email:

Add A Message:

Your Message Has Been Sent

Thank You

Email This Listing To A Friend

Send to Friend
2883 Ahlem, Turlock, CA 95382

Hello ,

thought you might be interested in the following property:

2883 Ahlem

Turlock, CA 95382

Click Here To View More Information

Send to Friend
2883 Ahlem, Turlock, CA 95382

Hello ,

thought you might be interested in the following property:

2883 Ahlem

Turlock, CA 95382

Click Here To View More Information

Your Name:

Your Email:

Your Friend's Name:

Your Friend's Email:

Add A Message:

This Listing Has Been Sent

Thank You

 


2883 Ahlem

Turlock, CA 95382

[GET DIRECTIONS]


Start: 

End: 

2883 Ahlem

Turlock, CA 95382

$549,000

Listed On 04/08/2019

Status: Active

4 Bed / 2 Bath
2,247 Square Feet (PER ASSESSOR/AUTO-FILL)
0.22 Acres

Listing #19020173 (METROLIST MLS)

London Properties, Ltd.

LONDON PROPERTIES, LTD.

REALTOR® / Lic. #00463722

559.436.4071

info@londonproperties.com

London Properties

Presented By:

London Properties, Ltd.

(559) 436-4071

Email London

London Properties, Ltd.

[GET DIRECTIONS]

2883 Ahlem

Turlock, CA 95382

2883 Ahlem

Turlock, CA 95382

[GET DIRECTIONS]


London Properties, Ltd.

Presented By:

London Properties, Ltd.

(559) 436-4071

Email London

Presented By:

London Properties, Ltd.

(559) 436-4071

Email London

London Properties, Ltd.

$549,000 4 Bed / 2 Bath 2,247 Square Feet (PER ASSESSOR/AUTO-FILL) 0.22 Acres Status: Active Listing #19020173 (METROLIST MLS) Listed On 04/08/2019

New Price, PREMIER LEGENDS LOCATION, Upgrades: Spacious Formal Dining/Living. Two Bay Window features offer an Abundance of Natural Light, Reflecting upon Impressive Grand Ceilings. GRANITE Counters, Kit OPEN to Separate Family Rm, GAS Fireplace Insert, HARDWOOD FLOORS, Berber Carpets in Bedrooms. MASTER SUITE; Relaxing Oval-JETTED-Tub, Dual Sink Vanity, 2 Closets. PRIVATE BACK YARD, Pergola & Covered Patio, Low Maintenance Landscaping. French Doors @ OFFICE/4th Bed. Inside Laundry plus Sink. Finished 3-CAR GARAGE, Central VAC, SOFT-WATER, Whole House Fan, ALARM, Electrical SUPPLY for Spa, NEW HVAC SYSTEM 2017. Super Clean Ready to Occupy. Schools nearby: Turlock Christian, Dutcher Middle, Dennis Earl.
Get More Info Or Schedule A Viewing

Please provide the following information and
one of our customer service representatives will assist you.

First Name:

Last Name:

Cell Phone:

Other Phone:

Email:

Add A Message:

Your Message Has Been Sent

Thank You

Email This Listing To A Friend

Your Name:

Your Email:

Friend's Name:

Friend's Email:

Add A Message:

This Listing Has Been Sent

Thank You

Mortgage Calculator
Mortgage Calculator
Down Payment (10%)
Total Purchase Price
Choose Your Rate
Loan Terms In Years
Estimated Payment
* This estimate does not include property tax or any lender required insurances
Get Pre-Approved For A Loan
Get Crime Data
Share: 

General Information
Property Subtype(s) 1 House on Lot Subtype Description Detached, Semi-Custom
Style Contemporary Census Tract 39.07
APN 073 042 049 000 Year Built 2003
Remodeled/Updated Unknown County Stanislaus
Area 20302 Lot Dimensions 9,483.012 sqft
Parcel Description Level, Shape Regular, Trees Few, Other-Rmks Zoning RESIDENTIAL
Tract/Builder LEGENDS # of Stories 1
Sewer/Water Meter on Site, Public District Sewer In & Connected, Public Sewer
Cross Streets EDGEWOOD Location Other-Rmks
Directions LEGENDS LOCATION: from MONTE VISTA nearby BERKELEY @ MARKLEY PARK. take BROOKSTONE DR, to PINEHURST DR, to AHLEM WAY, cross-st; EDGEWOOD. Energy Efficiency Ceiling Fan(s), Dual Pane Full, Insulation, Smart Vent, Whole House Fan
Equipment Cable TV Installed, Central Vacuum, Central Vac Plmd, Gas Water Heater, Water Cond Eqp Owned, Window Furnishings Improvements Sidewalk/Curb/Gutter, Street Lights
Miscellaneous Cathedral Ceiling, Patio Covered    
Property Subtype(s) 1 House on Lot
Subtype Description Detached, Semi-Custom
Style Contemporary
Census Tract 39.07
APN 073 042 049 000
Year Built 2003
Remodeled/Updated Unknown
County Stanislaus
Area 20302
Lot Dimensions 9,483.012 sqft
Parcel Description Level, Shape Regular, Trees Few, Other-Rmks
Zoning RESIDENTIAL
Tract/Builder LEGENDS
# of Stories 1
Sewer/Water Meter on Site, Public District
Sewer In & Connected, Public Sewer
Cross Streets EDGEWOOD
Location Other-Rmks
Directions LEGENDS LOCATION: from MONTE VISTA nearby BERKELEY @ MARKLEY PARK. take BROOKSTONE DR, to PINEHURST DR, to AHLEM WAY, cross-st; EDGEWOOD.
Energy Efficiency Ceiling Fan(s), Dual Pane Full, Insulation, Smart Vent, Whole House Fan
Equipment Cable TV Installed, Central Vacuum, Central Vac Plmd, Gas Water Heater, Water Cond Eqp Owned, Window Furnishings
Improvements Sidewalk/Curb/Gutter, Street Lights
Miscellaneous Cathedral Ceiling, Patio Covered

Nearby Amenities

Restaurants

Groceries

Nightlife

Shopping

Arts & Entertainment

Dust Bowl Downtown Taproom

Dust Bowl Downtown Taproom

4.0 star rating

(613 Reviews)

American (New)

$$

Villa Napoli

Villa Napoli

4.5 star rating

(292 Reviews)

Italian

$$

Table 26

Table 26

4.0 star rating

(484 Reviews)

Seafood

$$

La Mo Cafe

La Mo Cafe

4.5 star rating

(363 Reviews)

Breakfast & Brunch

$$

Crust & Crumb

Crust & Crumb

4.5 star rating

(230 Reviews)

Pizza

$$

10 East Kitchen & Taphouse

10 East Kitchen & Taphouse

4.0 star rating

(534 Reviews)

American (New)

$$

Kraving Kebab Pizza

Kraving Kebab Pizza

4.5 star rating

(202 Reviews)

Pizza

$$

Ju Ju Thai Cuisine

Ju Ju Thai Cuisine

4.5 star rating

(237 Reviews)

Thai

$$

Patogh Restaurant

Patogh Restaurant

4.0 star rating

(161 Reviews)

Middle Eastern

$$

Manna Korean Cuisine

Manna Korean Cuisine

4.5 star rating

(141 Reviews)

Korean

$$

Pho 7 Anh

Pho 7 Anh

4.0 star rating

(217 Reviews)

Vietnamese

$

Main Street Footers

Main Street Footers

4.0 star rating

(162 Reviews)

Hot Dogs

$

La Mo

La Mo

4.5 star rating

(135 Reviews)

Mexican

$$

Mundo's Latin Grill

Mundo's Latin Grill

4.0 star rating

(149 Reviews)

Latin American

$$

Toscana's Ristorante

Toscana's Ristorante

4.0 star rating

(110 Reviews)

Italian

$$

Center Street Grill

Center Street Grill

4.0 star rating

(121 Reviews)

Steakhouses

$$

AJ's Cafe & Grill

AJ's Cafe & Grill

3.5 star rating

(160 Reviews)

Breakfast & Brunch

$$

Loza Wine & Crepes

Loza Wine & Crepes

4.0 star rating

(176 Reviews)

Creperies

$$

El Asadero Taco Shop No 2

El Asadero Taco Shop No 2

4.0 star rating

(140 Reviews)

Mexican

$

Vito's Ristorante & Pizzeria

Vito's Ristorante & Pizzeria

4.0 star rating

(185 Reviews)

Pizza

$$


Property/Unit Features
Handicap Access Grab Bars, Wheelchair Access    
Handicap Access Grab Bars, Wheelchair Access

School Information
School District Stanislaus Elementary School Denair Unified
Junior High School Denair Unified High School Denair Unified
School District Stanislaus
Elementary School Denair Unified
Junior High School Denair Unified
High School Denair Unified

Interior
Rooms Dining Room, Home Office Room, Living Room, Master Suite, Separate Family Room Master Bedroom Closet, Closet Walk-In, Outside Access
Heating / Cooling Central, Fireplace Insert, Natural Gas / Central, Other-Rmks Foundation Concrete Slab
Flooring Carpet, Tile, Wood # of Fireplaces 1
Fireplace Type Family Room, Gas Log, Insert Laundry Cabinets, Gas Hook-Up, Inside Room, Sink
Bath Features Double Sinks, Tile, Tub w/Shower Over Kitchen Counter Granite, Island w/Sink, Kitchen/Family Combo, Pantry Cabinet, Dishwasher, Disposal, Hood Over Range, Ice Maker Plumbed, Microwave B/I, Range Gas F/S
Dining Room Features Breakfast Nook, Dining Bar, Formal Area    
Rooms Dining Room, Home Office Room, Living Room, Master Suite, Separate Family Room
Master Bedroom Closet, Closet Walk-In, Outside Access
Heating / Cooling Central, Fireplace Insert, Natural Gas / Central, Other-Rmks
Foundation Concrete Slab
Flooring Carpet, Tile, Wood
# of Fireplaces 1
Fireplace Type Family Room, Gas Log, Insert
Laundry Cabinets, Gas Hook-Up, Inside Room, Sink
Bath Features Double Sinks, Tile, Tub w/Shower Over
Kitchen Counter Granite, Island w/Sink, Kitchen/Family Combo, Pantry Cabinet, Dishwasher, Disposal, Hood Over Range, Ice Maker Plumbed, Microwave B/I, Range Gas F/S
Dining Room Features Breakfast Nook, Dining Bar, Formal Area

Exterior
Lot Acres (approx) 0.22 Lot Sq Ft (approx) 9,483
Direction Faces East Elevation 0
Road Description Paved, Public Maintained Garage Attached, Garage Door Opener, Paved Drive, Uncov Prkng Spc (2+)
Garage Spaces 3 # of Carport Spaces 0
Roofing Tile Exterior Stone, Stucco
Construction Frame, Stone, Wood Landscaping Back, Fenced Back, Front, Sprinkler Auto F&R, Wood Fence
Spa No Pool No
Detached Structures Pergola, Storage, Tool Shed Horse Property Features No
Lot Acres (approx) 0.22
Lot Sq Ft (approx) 9,483
Direction Faces East
Elevation 0
Road Description Paved, Public Maintained
Garage Attached, Garage Door Opener, Paved Drive, Uncov Prkng Spc (2+)
Garage Spaces 3
# of Carport Spaces 0
Roofing Tile
Exterior Stone, Stucco
Construction Frame, Stone, Wood
Landscaping Back, Fenced Back, Front, Sprinkler Auto F&R, Wood Fence
Spa No
Pool No
Detached Structures Pergola, Storage, Tool Shed
Horse Property Features No

Miscellaneous Data
Reports Available CC & R's REO/Bank Owned No
Reports Available CC & R's
REO/Bank Owned No

Mobile Home & Assoc.
HOA No    
HOA No

Courtesy of Cathy Grelle, Century 21 MM
IDX provided by Reliance Marketing.

Metrolist
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

2883 Ahlem, Turlock, CA 95382
 
2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382 2883 Ahlem, Turlock, CA 95382

UPDATING...

Good Morning,

Thank You

Your sign-in has been received.

Searching