Title Page Background
DEBUG FN args: Array ( [0] => 101 [1] => [2] => [3] => agent ) BEFORE: Site: 101 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 101 Igate: njhud LocID: 101 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 101 AND i.igate IN ('azhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 101 [1] => [2] => [3] => lender ) BEFORE: Site: 101 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 101 Igate: njhud LocID: 101 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 101 AND i.igate IN ('azhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 101 [1] => [2] => [3] => other ) BEFORE: Site: 101 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 101 Igate: njhud LocID: 101 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 101 AND i.igate IN ('azhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

3331 Calhoun Cove
San Antonio, TX 78253-6423

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $600,000
Beds: 4
Baths:
Status: Active
SqFt: 3636 Square Feet
Agency: Kimberly Howell Properties

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Flooring: Carpet, Tile, Tile - Ceramic
Heating: Central Furnace
Interior Features: High Speed Internet, High Ceilings, Eat-in Kitchen, Breakfast Bar, Telephone, Open Floor Plan, Cable Tv Available, Walk In Closets, Separate Dining Room, ISLAND KITCHEN, GAME ROOM, WALK-IN PANTRY, Laundry Room, Attic - Pull Down Stairs, Liv/Din Combo, Mechanical Fresh Air, Enhanced Air Filtration, Utility Room Inside, Laundry Main Level, Two Eating Areas, 1st Floor Lvl/No Steps, Three Living Area, Secondary Bedroom Down, Pull Down Storage, Attic - Storage Only, Attic - Attic Fan, Attic - Partially Floored
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Kitchen, Family Room, Living Room, Utility Room
Utilities: Cable Available, Phone Available

Window Features

Exterior Features: None, Double Pane Windows, Sprinkler System, Covered Patio, Privacy Fence, Patio Slab
Fencing: Fenced, Privacy
Parking Features: Garage, Oversized
Patio and Porch Features: Patio
Roof: Composition
View: City

Neighborhood/Schools

Elementary School/District: Cole/Tippecanoe School Corp.
Middle/Junior High School/District: /NORTHSIDE I.S.D.
High School/District: Taft/Taft ISD
Subvidision Name:

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Say hello to your new home with this extraordinary home nestled in the Preserve at Alamo Ranch community. This four bedroom, three and a half-bath residence offers an abundance of space and luxury features that will make you feel right at home. As you step inside, you'll be greeted by a formal living room that seamlessly connects to a dining area, perfect for hosting your special occasions. The family room opens up to a kitchen and breakfast room (large enough to be a dining room) creating an inviting space for time spent with loved ones and entertaining guests. The kitchen is designed for the home chef, with granite countertops, a large island with a breakfast bar, a secondary island for prep work, rich wood cabinets, and ample storage space. Stainless steel appliances and recessed lighting add a touch of modern elegance to what surely will be the most popular room in the house. Experience comfort and relaxation in the spacious primary bedroom that accommodates an additional sitting room that could also function as an office. The primary bath is a haven of luxury with granite counters, separate vanities, a corner tub placed next to a large frosted window for natural light, and a separate shower. Upstairs, you'll find a big game room with a bathroom, perfect for entertaining guests or enjoying fun-filled game nights or the latest streaming movies. Need more living space? We have you covered with a downstairs den just off of the family room for those times when you want a little privacy, but still be a part of the entertaining in the kitchen area. Outside, a wide covered patio equipped with fans awaits, ideal for alfresco dining or simply enjoying the breeze. The property is fully fenced for privacy and offers a three car garage with one separate bay, providing excellent storage space that doesn't have to keep the cars from parking inside. The home also comes with a new water softener ensuring you have the best water for all your needs. Plus, you can enjoy all the amenities offered by the Preserve at Alamo Ranch community, from the swimming pool and playground to the sports courts.
MlsNumber: --


Listing Provided By: Kimberly Howell Properties, original listing
Phone: (210) 861-0188
Office Phone: (210) 493-6888
Agent Name: Kimberly Howell
Disclaimer: Copyright © 2024 San Antonio Board of Realtors®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => mohave-mohave-valley [3] => AZ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: mohave-mohave-valley State: AZ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: mohave-mohave-valley State: AZ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 101 AND i.igate IN ('azhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Lois Briesemeister
ASCIIUS Southwest Real Estate Sales & Leasing
Mobile: (928) 201-0267

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App