DEBUG INFO: 1

London Properties - The Most Trusted Name In Real Estate

Contact us directly - 436-4000

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:

 

    

Get More Info Or Schedule A Viewing

Email This Listing To A Friend

Print A Flyer

PREMIER LEGENDS LOCATION, FORMAL DINING/LIVING, ENJOY AN ABUNDANCE OF NATURAL LIGHT & GRAND CEILING TREATMENTS. GRANITE COUNTERS IN KITCHEN /OPEN TO SEPARATE FAMILY RM, GAS FIREPLACE INSERT, HARDWOOD FLOORS, BERBER CARPET IN BEDROOMS. SPACIOUS MASTER SUITE HAS RELAXING JETTED-OVAL-TUB, DUAL VANITIES, 2 CLOSETS, PLUS ACCESS TO PRIVATE BACK YARD, PERGOLA & COVERED PATIO, LUSH LANDSCAPING. 3 BEDS, 4TH BED/OFFICE WITH FRENCH DOORS, INSIDE LAUNDRY ROOM /SINK, FINISHED 3 CAR GARAGE, CENTRAL VAC, SOFT-WATER, WHOLE HOUSE FAN, ALARM, ELECTRICAL SUPPLY FOR SPA, & NEW HVAC SYSTEM 2017. SEE UPGRADED AMENITIES LIST. SUPER CLEAN READY TO OCCUPY.

Mortgage Calculator

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

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

Hello ,

thought you might be interested in the following property:

2883 Ahlem

Turlock, CA 95382

Click Here To View More Information

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

$574,900

Listed On 03/16/2019

Status: Active

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

Listing #19020173 (METROLIST MLS)

LONDON PROPERTIES, LTD.

REALTOR® / Lic. #00463722

559.436.4071

info@londonproperties.com

Presented By:

London Properties, Ltd.

(559) 436-4071

Email London


[GET DIRECTIONS]

2883 Ahlem

Turlock, CA 95382

2883 Ahlem

Turlock, CA 95382

[GET DIRECTIONS]


Presented By:

London Properties, Ltd.

(559) 436-4071

Email London

Presented By:

London Properties, Ltd.

(559) 436-4071

Email London

$574,900 3 Bed / 2 Bath 2,247 Square Feet (PER ASSESSOR/AUTO-FILL) 0.22 Acres Status: Active Listing #19020173 (METROLIST MLS) Listed On 03/16/2019

PREMIER LEGENDS LOCATION, FORMAL DINING/LIVING, ENJOY AN ABUNDANCE OF NATURAL LIGHT & GRAND CEILING TREATMENTS. GRANITE COUNTERS IN KITCHEN /OPEN TO SEPARATE FAMILY RM, GAS FIREPLACE INSERT, HARDWOOD FLOORS, BERBER CARPET IN BEDROOMS. SPACIOUS MASTER SUITE HAS RELAXING JETTED-OVAL-TUB, DUAL VANITIES, 2 CLOSETS, PLUS ACCESS TO PRIVATE BACK YARD, PERGOLA & COVERED PATIO, LUSH LANDSCAPING. 3 BEDS, 4TH BED/OFFICE WITH FRENCH DOORS, INSIDE LAUNDRY ROOM /SINK, FINISHED 3 CAR GARAGE, CENTRAL VAC, SOFT-WATER, WHOLE HOUSE FAN, ALARM, ELECTRICAL SUPPLY FOR SPA, & NEW HVAC SYSTEM 2017. SEE UPGRADED AMENITIES LIST. SUPER CLEAN READY TO OCCUPY.
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
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

4.0 star rating

(607 Reviews)

American (New)

$$

Villa Napoli

4.5 star rating

(289 Reviews)

Italian

$$

Table 26

4.0 star rating

(476 Reviews)

Seafood

$$

La Mo Cafe

4.5 star rating

(358 Reviews)

Breakfast & Brunch

$$

Crust & Crumb

4.5 star rating

(229 Reviews)

Pizza

$$

10 East Kitchen & Taphouse

4.0 star rating

(518 Reviews)

American (New)

$$

Ju Ju Thai Cuisine

4.5 star rating

(237 Reviews)

Thai

$$

Kraving Kebab Pizza

4.5 star rating

(187 Reviews)

Pizza

$$

Patogh Restaurant

4.0 star rating

(159 Reviews)

Middle Eastern

$$

Manna Korean Cuisine

4.5 star rating

(136 Reviews)

Korean

$$

Pho 7 Anh

4.0 star rating

(213 Reviews)

Vietnamese

$

Main Street Footers

4.0 star rating

(155 Reviews)

Hot Dogs

$

La Mo

4.5 star rating

(128 Reviews)

Mexican

$$

Mundo's Latin Grill

4.0 star rating

(147 Reviews)

Latin American

$$

AJ's Cafe & Grill

4.0 star rating

(156 Reviews)

Breakfast & Brunch

$$

El Asadero Taco Shop No 2

4.0 star rating

(136 Reviews)

Mexican

$

Center Street Grill

4.0 star rating

(121 Reviews)

Steakhouses

$$

Toscana's Ristorante

4.0 star rating

(106 Reviews)

Italian

$$

Loza Wine & Crepes

4.0 star rating

(161 Reviews)

Creperies

$$

Nagina Palace

4.0 star rating

(191 Reviews)

Indian

$$


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
Possible Bedrooms 4.00 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, Gas Piped, 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
Possible Bedrooms 4.00
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, Gas Piped, 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.


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.

 

UPDATING...

Good Morning,

Thank You

Your sign-in has been received.

Searching