Welcome to Terraces at Fieldstone

ABOUT

Come home to Terraces at Fieldstone Apartments in Conyers, GA! Our apartments are home to a fantastic location where endless opportunities for work and play collide. At our apartments, you can choose from our apartments that are complete with everything you need to always feel right at home. Here you'll find yourself surrounded by an amenity-rich community and beautiful scenery. Our apartments place you in the best destination to embrace Conyers living. This prime neighborhood will give you easier commutes and allow you to experience the perfect balance of modern city life and relaxation. Ready to step into your dream apartment? Apply now to Terraces at Fieldstone in Conyers today.

Address

50 Loch Haven Drive South East
Conyers, Georgia
30013

Phone

P: (770) 761-2188

Office Hours

Monday - Friday: 09:00 AM - 06:00 PM
Saturday: 10:00 AM - 05:00 PM
Sunday: Closed

GALLERY

Living Room | Terraces at Fieldstone
Dining Room | Terraces at Fieldstone
Kitchen | Terraces at Fieldstone
Bedroom | Terraces at Fieldstone
Fully Equipped Kitchen | Terraces at Fieldstone
Bathroom | Terraces at Fieldstone
Bathroom | Terraces at Fieldstone
Monument Sign | Terraces at Fieldstone
Clubhouse Exterior | Terraces at Fieldstone
Clubhouse Interior | Terraces at Fieldstone
Lobby | Terraces at Fieldstone
Leasing Office | Terraces at Fieldstone
Fitness Center | Terraces at Fieldstone
Swimming Pool | Terraces at Fieldstone
Pool | Terraces at Fieldstone
Fire Pit | Terraces at Fieldstone
Sports Court | Terraces at Fieldstone
Bark Park | Terraces at Fieldstone
Playground | Terraces at Fieldstone
Lake | Terraces at Fieldstone
Picnic Area | Terraces at Fieldstone
Picnic Table | Terraces at Fieldstone
Exterior | Terraces at Fieldstone
Garages | Terraces at Fieldstone
Apartment Exterior | Terraces at Fieldstone

FLOOR PLANS

1 Bedroom

1 Bedroom

SQ FEET: 823

BEDROOMS: 1

BATHROOMS: 1

DEPOSIT: 250

PRICE: $1295

AVAILABLE: 2

WEB SPECIAL:

2 Bedroom 1 Bath

2 Bedroom 1 Bath

SQ FEET: 1155

BEDROOMS: 2

BATHROOMS: 1

DEPOSIT: 250

PRICE: $1525

AVAILABLE: 1

WEB SPECIAL:

2 Bedroom 2 Bath 1186

2 Bedroom 2 Bath 1186

SQ FEET: 1186

BEDROOMS: 2

BATHROOMS: 2

DEPOSIT: 250

PRICE: Contact Us for More Details

WEB SPECIAL:

2 Bedroom 2 Bath 1236

2 Bedroom 2 Bath 1236

SQ FEET: 1236

BEDROOMS: 2

BATHROOMS: 2

DEPOSIT: 250

PRICE: $1483

AVAILABLE: 2

WEB SPECIAL:

3 Bedroom 2 Bath 1367

3 Bedroom 2 Bath 1367

SQ FEET: 1367

BEDROOMS: 3

BATHROOMS: 2

DEPOSIT: 250

PRICE: $1561

AVAILABLE: 1

WEB SPECIAL:

3 Bedroom 2 Bath 1429

3 Bedroom 2 Bath 1429

SQ FEET: 1429

BEDROOMS: 3

BATHROOMS: 2

DEPOSIT: 250

PRICE: $1650

AVAILABLE: 2

WEB SPECIAL:

3 Bedroom 2 Bath 1470

3 Bedroom 2 Bath 1470

SQ FEET: 1470

BEDROOMS: 3

BATHROOMS: 2

DEPOSIT: 250

PRICE: $1741

AVAILABLE: 1

WEB SPECIAL:

2 Bedroom 2 Bath 1212

2 Bedroom 2 Bath 1212

SQ FEET: 1212

BEDROOMS: 2

BATHROOMS: 2

DEPOSIT: 250

PRICE: $1545

AVAILABLE: 2

WEB SPECIAL:

AMENITIES

Apartment

  • Fully Equipped Kitchen
  • Open Floor Plan
  • Granite-Inspired Counter Tops
  • Chic Two Toned Scheme
  • Private Screened Patio or Balcony*
  • Designer Lighting Package
  • Cozy Wood Burning Fireplaces*

Property

  • Clubhouse
  • Sparkling Pool
  • Athletic Facility with Redwood Dry Heat Sauna
  • Lighted Tennis Courts & Playground
  • Car Care Center with Vacuum
  • Scenic 10 Acre Lake, Jogging Trails & Fishing
  • Picnic Areas with Stacked Stone Charcoal Grills
  • Butterfly Garden
  • Professional & Responsive Management
  • Convenient Location

REVIEWS

Balinda Mills

Stars: 5

Sep 18, 2023

Laura Torres Castillo

Stars: 4

Aug 24, 2023

Shambrina Gray

Stars: 5

Dec 12, 2022

Clifton Walker

Stars: 4

Dec 02, 2022

Kalin Copeland

Stars: 4

My experience with them has been pleasant so far. The new manager Ms.Love was so sweet and very helpful!!! I loved everything about her ❤️

Nov 06, 2022

Vilethia Floyd

Stars: 4

I have been living at Terraces at Fieldstone since Dec 2019. The experience has been pleasant even with the recent change in management company. From my experience, with most transitional phases there will be issues and concerns. I understand it takes time, patience and grace to get through them. Kenyatta and her team have pleasant, professional and helpful regarding any concerns that I had. Recently, AMC hired resident coordinator Joy Brown-ApartmentLife who has been doing an excellent job with hosting resident community events.

Sep 19, 2022

Stephanie Wright

Stars: 5

I like giving compliments when due. Kenyatta is one of the most pleasant and caring people I’ve spoke with in some time now. I’ve looked at quite a few apartments around in the area and I was very impressed with your community. Your office staff is the first impression and I can say the best impression.

Sep 15, 2022

K Friday

Stars: 5

When I first came to the leasing office I was greeted with a smile from Ms. Kenyatta. She was so patient and helpful throughout the entire process. Due to her knowledge and level of professionalism displayed I will highly recommend this community to all my friends and love ones. Again I thank her and the staff of Terraces at Fieldstone for the exceptional customer service I received!

Sep 05, 2022

Marcia Reynolds

Stars: 4

Belinda was professional and any questions I had she answered them. Grounds very maintained. Pest control comes out every Thursday very quite I would recommend Terrace Fieldstone ask for Belinda

Sep 02, 2022

Marcia Reynolds

Stars: 4

Belinda was professional and any questions I had she answered them. Grounds very maintained. Pest control comes out every Thursday very quite I would recommend Terrace Fieldstone ask for Belinda. I moved in in August prior company left. Now a new management is here. Garbage is overflowing. Roaches on my furniture I walk around with Roaches spray and I pay for pest control no one came out spray. L

Sep 02, 2022

Tyrice Bethely

Stars: 5

I came to look at an apartment with a close friend who recently moved here,while I’ve been a resident of Georgia my entire life ,I had no idea this property had such a pleasant staff. No question was to overwhelming and my friend had plenty. I love some of the comfortable yet cozy floor plans and if I ever thought of moving to this area based on our treatment I would definitely consider this property. Thank you for a pleasant environment and staff.

Sep 02, 2022

Jasmere Brown

Stars: 5

Friendly staff beautiful property

Sep 02, 2022

Amanda Wolaver

Stars: 5

I’ve been working with Kenyatta for a while now (I’m one of her vendors) and she by far is one of the best manager’s. I have seen her interact with her residents and she truly cares. She is on top of all of her move outs and getting the unit ready for the next resident. I absolutely love being one of her vendors!!

Sep 02, 2022

Shawn

Stars: 5

Kenyatta has been such a great help at this property! Always pleasant and nice!! If I could, I would hire her away from here!!!

Sep 01, 2022

Adrena Cooley

Stars: 5

I have to truly commend Terraces at Fieldstone because I have had the best experience. Kenyatta went above and beyond to assist me. Kudos to Kenyatta and the staff.

Sep 01, 2022

L J

Stars: 5

I was super stressed about relocating my family from Savannah to Conyers. I was immediately put at ease when I walked into the office of Terraces at Fieldstone. Immediately, I received a warm and welcoming greeting from the CM Kenyatta. After the tour of the unit and the property, I knew Terraces at Fieldstone would be our new home. Since moving in, the property grounds are always clean and well maintained. I would highly recommend Terraces at Fieldstone to anyone.

Sep 01, 2022

L. Jones

Stars: 5

I was super stressed about relocating my family from Savannah to Conyers. I was immediately put at ease when I walked into the office of Terraces at Fieldstone. Immediately, I received a warm and welcoming greeting from the CM Kenyatta. After the tour of the unit and the property, I knew Terraces of Eden would be our new home. Since moving in, the property grounds are always clean and well maintained. I would highly recommend Terraces at Fieldstone to anyone.

Sep 01, 2022

Terna Davis

Stars: 5

Love this beautiful property and the new manager Kenyatta’s really sprucing up the place. Keep up the good work!👍🏽

Aug 31, 2022

Adrena C.

Stars: 5

All outstanding thus far!! I have nothing but positive things to say about Terraces at Fieldstone. Kenyatta has been outstanding with superior communication.

Aug 31, 2022

Jessica Tillman

Stars: 5

Kenyatta made this experience so much better. She was able to answer all of my questions and made everything simple for me to understand. She was very kind and polite. Kenyatta is very professional nice and respectful.

Aug 31, 2022

Cheryl

Stars: 5

Kenyatta was very professional. She gave great service and very personable. She provided great information about the property. Cheryl

Aug 31, 2022

Eric Auten

Stars: 5

Kenyatta and her staff are so great to work with. They make you feel right at home from the first greeting. The property is beautiful and well kept. If your looking for a comfortable, friendly , family environment stop in and get to know them. You won’t regret it.

Aug 31, 2022

Patrick

Stars: 5

The service from the office was very welcoming and also some of the best I’ve ever gotten from an establishment.

Aug 31, 2022

Skye Couture

Stars: 5

Great place to live. Grounds are well kept and the staff is amazing!!!!

Aug 31, 2022

Branden Rooker

Stars: 5

Aug 27, 2022

Bubba Knox

Stars: 5

Aug 27, 2022

Torien Moore (Tj)

Stars: 5

Very family friendly environment. The property manager Kenyatta Kimble is very professional and makes sure he residents are well taken care of.

Aug 27, 2022

Vilethia F.

Stars: 5

My family and I moved to Terraces At Fieldstone in 2019. My experience so far has been pleasant. Recently, I was informed that Terraces at Fieldstone had gone through a transition from one management team to another. Kenyatta and her team are professional, courteous and helpful. Any questions or issues that I had was answered in a timely manner.

Aug 27, 2022

Josiah Damon

Stars: 5

Aug 27, 2022

Cheryll Martin

Stars: 5

Aug 19, 2022

Katrina Smith

Stars: 5

I moved to Terraces at Fieldstone in the beginning of July. My experience with Kenyatta and her team was pleasant. I was informed that they had just gone through a transition from one management team to another. Its an older complex so, some units may need a little touch up but the grounds are well kept.

Aug 18, 2022

Tiffany Lynn

Stars: 4

OMG its been a weird experience from June until August until I finally spoke with Kenyatta! Shes been amazing and very helpful

Aug 17, 2022

MyBody Bae

Stars: 4

OMG its been a weird experience from June until August until I finally spoke with Kenyatta! Shes been amazing and very helpful

Aug 17, 2022

Kenyatta

Stars: 5

I have been living in Terraces at Fieldstone this complex for quite a few years and I finally feel as if I have professional management. Kenyatta exemplifies genuine care and concern for the tenants and the property.

Aug 15, 2022

Rita Wortham

Stars: 5

I gave Terraces at Fieldstone a 1 star previously. I feel that I have to change it. I was so angry from the previous managements attitudes that when the new staff took over, I didn’t realize the turmoil the new staff inherited. I felt like I needed to regroup and talk to everyone in person because my father wanted to stay here. Kenyatta, Belinda, and the regional manager were great to my father after we sat down and had a conversation. Sometimes as adults we need to sit down and have adult conversations and check attitudes at the door on both sides. All I want is my father to be happy and secure in his place. We all make mistakes and sometimes you have to step back and work it out between each other without conflict. Thanks again Terraces At Fieldstone Staff

Aug 04, 2022

Odee Chic

Stars: 5

I give this place 5 stars because although the previous managers were horrible the new staff members are professional courteous and patient. The residents are rude and I have witnessed the rudeness they give out to the staff. Its basically adults not having good comprehension skills. I will stay another 5 years here !

Aug 02, 2022

Candace Lang

Stars: 5

When I was moving in Kenyatta was a BIG help. She made my moving process easy as possible. She was very nice, respectful, and helped me out as much as she could even with everything that was going on. I’ve been here a month now and I like it here. Thank you Kenyatta!!!

Jul 29, 2022

Robert Cooper

Stars: 5

Office staff was very pleasant to work with. Grounds are help clean and a very nice place to live..

Jul 29, 2022

Key Fancy

Stars: 5

Love everything about this community! The NEW staff is wonderful!!!! So glad for fresh friendly faces . Love the new CM she's absolutely wonderful

Jul 13, 2022

Breanna

Stars: 5

Kenyatta is amazing and she’s working diligently hard to take care of the property and tenants here at terrace at fieldstone. She’s kind and very understanding.

Jul 11, 2022

Breanna

Stars: 5

Kenyatta is amazing and she working diligently hard at taking care of the property and tenants. Be kind!!

Jul 11, 2022

Breanna Long

Stars: 5

Kenyatta is an amazing!! She is working diligently hard to take care of the property and tenants. Seriously the reason I’m moving here.

Jul 11, 2022

shane hunter

Stars: 5

Everyone from the property manager Nicky, Amy the assistant and Eric the service manager worked Harland bent over backwards with my problem and got it fixed in a very expedient manner. Definitly would recommend this apartment complex to others

Feb 22, 2022

Esther Ahumada

Stars: 5

Jan 25, 2022

CEDRIC NEEDHAM

Stars: 4

Clean decent apartments

Dec 29, 2021

Lineeka Oliveras

Stars: 4

Oct 15, 2021

Dominic Oliveras

Stars: 5

Oct 08, 2021

Shauna Rush

Stars: 4

Dec 30, 2020

Jasmina Labudovic

Stars: 5

Dec 16, 2020

Cee Ce

Stars: 5

Nov 01, 2020

Lisa Winters

Stars: 4

I moved in a little over a month ago. The office staff (Mellase and Krystle) is GREAT!! Terraces at Fieldstone apartment complex is quiet and I love the lake view. They do an awesome job with the landscaping as well. I do have a couple minor concerns but I will speak with Management directly. I would definitely recommend Terraces at Fieldstone.

Nov 01, 2020

Rochelle Brown

Stars: 5

Love it here it’s serene and the apartment is so comfortable. 🥰 Maintenace request are quickly answered and the guys are so nice when they come to fix any issues you have.

Sep 01, 2020

Raqi Kells

Stars: 5

Aug 20, 2020

Chelby Slappy

Stars: 4

Aug 14, 2020

Anita Sylvester

Stars: 5

May 28, 2020

Lauren Labit

Stars: 5

May 27, 2020

Tamika Stradford

Stars: 4

I have had a nice experience living here. I love the convenience of shopping plazas and supermarkets. I do not like that the gates are always broken

May 14, 2020

Jami Germaine Jackson

Stars: 5

Enjoy living here. The property is kept beautifully. The staff s very cordial and attentive. The maintenance men are prompt and effective.

Mar 13, 2020

Ambient Knightz

Stars: 5

Feb 14, 2020

Maria Simmons

Stars: 5

Great place to live!

Sep 18, 2019

Daisy Franklin

Stars: 5

My experience here at Terraces at Fieldstone is amazing. The staff is great. Very professional and quick to respond to any concerns I may have had.

Sep 07, 2019

Samiyah Holloway

Stars: 5

Aug 23, 2019

Kris Smith

Stars: 4

Aug 14, 2019

Robby “Chef Rob” Harris

Stars: 5

Jul 08, 2019

Ankit Patel

Stars: 5

I have edited my rating after talking to NICKY GLOVER, very helpful and understanding lady, She took care of the mistake on their end. Thanks!

Jun 11, 2019

Meaghan Seals

Stars: 5

My husband and I love living here. Having the lake to walk around when I need exercise or time to myself is a plus for me. Location and Price were perfect for us both and if we weren’t able to find anything else when our lease was up we would be ok with renewing another lease here. Every morning I leave to take my daughter to school there is always someone already on the property somewhere cleaning up. This is by far the best complex we have ever stayed in. #SealsFamily

May 23, 2019

Nicole Barden

Stars: 5

So far so good. Maintenance sometimes falls behind but I've really enjoyed my stay here.

May 23, 2019

Dexter Andrews

Stars: 5

Since Greystar took over Terraces at Fieldstone Apartment complex, the community is reshaping. Terraces’ management (Nikki, Malase and Krystal) work together and are willing to help the residents the best way they can. Also, they all have worked hard to make better changes in this community with the upgraded work that was needed on the property. The community is still growing and with the staff we have in the office, they will continue to get the job done. Don’t listen to the negative impact people give you on management. They are truly all great individuals.

May 23, 2019

Sucelia Allen

Stars: 5

I love staying at Terrances at Fieldstone. I have been here for the last w years and it has been amazing. The office staff is really friendly including the maintenance people are very courteous. I love that they have different social activities for the residence lile the wine down Wednesday and birthday celebration every month Also, Crystal always have something special for the kids around every holiday. The kids in the neighborhood really like her. I would recommend these apartment to anyone looking for a family like community.

May 23, 2019

Shaun Long

Stars: 5

The staff here are very friendly and helpful!!

May 23, 2019

timari fears

Stars: 5

The management team headed by Nicky Glover is outstanding and Melaysia as well. Always humble and sweet.

May 23, 2019

Jovan Hooper

Stars: 4

I've lived here about 3 months now and the staff are always pleasant! They go out of their way to make you feel at home. The area is very nice, great landscaping and good neighbors. They keep it very clean and the apartments are nice; a bit over-priced for the way the apartments look in my opinion, but very nice nonetheless. Do be prepared to wait for service requests to be resolved. Would recommend this complex.

May 23, 2019

Chris Nixon

Stars: 5

May 22, 2019

David Calhoun

Stars: 5

Apr 10, 2019

Yokie Green

Stars: 5

Top notch, not just an apartment but a home. The management team headed by Nicky Glover is outstanding. They are attentive to the tenants needs at all times. The premises is beautifully maintained and clean. Never have i experienced an apartment complex thats been as impressive as The Terraces at Fieldstone apartments in Rockdale county. Thank you! Sincerely yg.

Mar 15, 2019

L Melna

Stars: 5

We've lived here for almost four years and recommend it to everyone we speak to! The front office is always accomodating and we appreciate how hard they work for the community. If you're looking for a clean, safe, and friendly environment this is where you want to be!

Feb 14, 2019

Donnaca Mitchell

Stars: 5

After a long hard search for an apartment I ran into this place. The first time I visited the community it was clean and quiet and I fell in love with the landscaping. I then decided to go in and apply and from the start to the end Krystal Clark was very professional polite and responsive to any of my questions! I have been living in my new apartment for 2 weeks now and I have no concerns. HOWEVER, I would suggest that the tenants get assign parking because I would love to park closer to my apartment when I get home late at night . but other than that this place is truely a charm

Oct 14, 2018

Anushya Raghuram

Stars: 4

Sep 16, 2018

Tris Adepoju

Stars: 4

Sep 08, 2018

Devina Patterson

Stars: 4

We have only been tenants for six months now. I remember reading the reviews on this community before moving in and some really worried me. However, we ultimately decided to just go off of our own experiences, which have been great. We have communicated with Krystal and Malaise in the front office during our move in process, as well as throughout our stay so far. Both have always been very kind and helpful to us so I'm not sure why there are so many people complaining about customer service. We live in an apartment with a lake view, and it is truly spectacular... the grounds are what sold me on moving here. We are definitely happy tenants so far. If I were to critique the community at all, it would be to say that like many others, I have noticed the front gate arms and the lake fountain not working properly several times since we have been here. HOWEVER, the gate arms are most likely broken from people tailgating others in and out of the complex and the bar coming down on their vehicle. There are plenty of signs posted that clearly state only one car at a time should drive through the gate. I DO NOT hold the apartment management liable for the broken arms, as long as they get fixed. I'm saddened that so many tenants/visitors break the rules then get angry that the gate arm is broken. Shame. My husband and I love this community. In fact, we are considering upgrading to a three bedroom once our lease is up. Unfortunately, most people that have great things to say, don't take the time to do a review. It is usually only those that have something to complain about that take the time to do it. I truly hope my review sheds some light and helps newcomers breathe easy about moving here.

Apr 30, 2018

Antoine Gardner

Stars: 5

Apr 18, 2018

Anastasia

Stars: 5

Apr 04, 2018

Faysha Mcmillian

Stars: 4

Apr 03, 2018

Amiee Whitley

Stars: 5

I’ve enjoyed living here for almost a year. No major issues and ones I have had the maintenance staff is always prompt and courteous.

Mar 31, 2018

Tajuana Trone

Stars: 5

Terraces at Fieldstone has made great strides to make this community GREAT. They’ve exceeded my expectation!

Mar 09, 2018

ERIC RUIZ PEREZ (erickqoh)

Stars: 4

Sep 23, 2016

Rickyia Weddington

Stars: 4

Mar 12, 2016

StruggleDays

Stars: 5

Enjoyed my stay

Feb 11, 2016

Ebonie Watson

Stars: 5

I have been a tenant here for a year and I must say it is one of the best places to live! It is beautiful, safe, and quiet. My husband and I have a 3 year old and we enjoy taking her to the playground in our complex or taking her for walks around the community's gorgeous lake. Their gym and sauna are also great! To have a sauna at an apartment complex is virtually unheard of, so I take full advantage! The staff in the leasing office are kind, easy to communicate with, and above all professional. The grounds are very well kept by maintenance, and they respond quickly to work orders. They even give you an opportunity to rate your maintenance experience after the work order is completed. I must say we are very pleased staying here. The best apartment complex in Conyers!

Oct 04, 2015

Chasney B

Stars: 4

I stayed here for a year. They never answer the phone ever! The grounds are nice and the community is quiet.

Sep 09, 2015

Seven Jones

Stars: 4

Aug 30, 2015

CONTACT US

We'll never share your email with anyone else.
(2.9ms) SELECT C.COLUMN_NAME AS field,C.DATA_TYPE AS type,C.COLUMN_DEFAULT AS defval,C.IS_NULLABLE AS nullable,columnproperty(object_id(C.TABLE_NAME),C.COLUMN_NAME,'IsIdentity') AS autoinc,T.CONSTRAINT_TYPE AS pkey FROM INFORMATION_SCHEMA.COLUMNS AS C LEFT OUTER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.TABLE_NAME=K.TABLE_NAME AND C.COLUMN_NAME=K.COLUMN_NAME AND C.TABLE_SCHEMA=K.TABLE_SCHEMA AND C.TABLE_CATALOG=K.TABLE_CATALOG LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS T ON K.TABLE_NAME=T.TABLE_NAME AND K.CONSTRAINT_NAME=T.CONSTRAINT_NAME AND K.TABLE_SCHEMA=T.TABLE_SCHEMA AND K.TABLE_CATALOG=T.TABLE_CATALOG WHERE C.TABLE_NAME='floorplan' AND C.TABLE_CATALOG='marketApts' (3.2ms) SELECT [U_MARKETING_NAME],[BED],[BATH],[SQFT],[AVAIL],[RENT_FROM],[SQFT_SORT],[SPECIAL_TEXT],[UNIT_LIMIT],[DEPOSIT],[PROPERTY_CODE],[SOFTWARE],[date_updated],(select U_MARKETING_NAME) AS [name],(select BED) AS [bedrooms],(select BATH) AS [bathrooms],(select SQFT) AS [square_feet],(select cast(RENT_FROM AS DECIMAL(7,2))) AS [price],(select 12 Months) AS [lease_term],(select DEPOSIT) AS [deposit],(select 0) AS [display_order],(select 1) AS [isRealTime] FROM [floorplan] WHERE PROPERTY_CODE = '890TAF' (1.9ms) SELECT C.COLUMN_NAME AS field,C.DATA_TYPE AS type,C.COLUMN_DEFAULT AS defval,C.IS_NULLABLE AS nullable,columnproperty(object_id(C.TABLE_NAME),C.COLUMN_NAME,'IsIdentity') AS autoinc,T.CONSTRAINT_TYPE AS pkey FROM INFORMATION_SCHEMA.COLUMNS AS C LEFT OUTER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.TABLE_NAME=K.TABLE_NAME AND C.COLUMN_NAME=K.COLUMN_NAME AND C.TABLE_SCHEMA=K.TABLE_SCHEMA AND C.TABLE_CATALOG=K.TABLE_CATALOG LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS T ON K.TABLE_NAME=T.TABLE_NAME AND K.CONSTRAINT_NAME=T.CONSTRAINT_NAME AND K.TABLE_SCHEMA=T.TABLE_SCHEMA AND K.TABLE_CATALOG=T.TABLE_CATALOG WHERE C.TABLE_NAME='UTYP_WEB_SPECIALS' AND C.TABLE_CATALOG='marketApts' (1.9ms) SELECT [SPECIALID],[RESMANPROPERTYID],[U_MARKETING_NAME],[EFFECTIVEDATE],[EXPIRATIONDATE],[SPECIAL_TEXT],[UNIT_LIMIT] FROM [UTYP_WEB_SPECIALS] WHERE RESMANPROPERTYID = '890TAF' and (EFFECTIVEDATE <= getdate()) and (EXPIRATIONDATE is null OR EXPIRATIONDATE >= getdate()) (0.4ms) SELECT [SPECIALID],[RESMANPROPERTYID],[U_MARKETING_NAME],[EFFECTIVEDATE],[EXPIRATIONDATE],[SPECIAL_TEXT],[UNIT_LIMIT] FROM [UTYP_WEB_SPECIALS] WHERE RESMANPROPERTYID = '890TAF' and (EFFECTIVEDATE <= getdate()) and (EXPIRATIONDATE is null OR EXPIRATIONDATE >= getdate()) (0.4ms) SELECT [SPECIALID],[RESMANPROPERTYID],[U_MARKETING_NAME],[EFFECTIVEDATE],[EXPIRATIONDATE],[SPECIAL_TEXT],[UNIT_LIMIT] FROM [UTYP_WEB_SPECIALS] WHERE RESMANPROPERTYID = '890TAF' and (EFFECTIVEDATE <= getdate()) and (EXPIRATIONDATE is null OR EXPIRATIONDATE >= getdate()) (0.4ms) SELECT [SPECIALID],[RESMANPROPERTYID],[U_MARKETING_NAME],[EFFECTIVEDATE],[EXPIRATIONDATE],[SPECIAL_TEXT],[UNIT_LIMIT] FROM [UTYP_WEB_SPECIALS] WHERE RESMANPROPERTYID = '890TAF' and (EFFECTIVEDATE <= getdate()) and (EXPIRATIONDATE is null OR EXPIRATIONDATE >= getdate()) (0.4ms) SELECT [SPECIALID],[RESMANPROPERTYID],[U_MARKETING_NAME],[EFFECTIVEDATE],[EXPIRATIONDATE],[SPECIAL_TEXT],[UNIT_LIMIT] FROM [UTYP_WEB_SPECIALS] WHERE RESMANPROPERTYID = '890TAF' and (EFFECTIVEDATE <= getdate()) and (EXPIRATIONDATE is null OR EXPIRATIONDATE >= getdate()) (0.4ms) SELECT [SPECIALID],[RESMANPROPERTYID],[U_MARKETING_NAME],[EFFECTIVEDATE],[EXPIRATIONDATE],[SPECIAL_TEXT],[UNIT_LIMIT] FROM [UTYP_WEB_SPECIALS] WHERE RESMANPROPERTYID = '890TAF' and (EFFECTIVEDATE <= getdate()) and (EXPIRATIONDATE is null OR EXPIRATIONDATE >= getdate()) (0.4ms) SELECT [SPECIALID],[RESMANPROPERTYID],[U_MARKETING_NAME],[EFFECTIVEDATE],[EXPIRATIONDATE],[SPECIAL_TEXT],[UNIT_LIMIT] FROM [UTYP_WEB_SPECIALS] WHERE RESMANPROPERTYID = '890TAF' and (EFFECTIVEDATE <= getdate()) and (EXPIRATIONDATE is null OR EXPIRATIONDATE >= getdate()) (0.4ms) SELECT [SPECIALID],[RESMANPROPERTYID],[U_MARKETING_NAME],[EFFECTIVEDATE],[EXPIRATIONDATE],[SPECIAL_TEXT],[UNIT_LIMIT] FROM [UTYP_WEB_SPECIALS] WHERE RESMANPROPERTYID = '890TAF' and (EFFECTIVEDATE <= getdate()) and (EXPIRATIONDATE is null OR EXPIRATIONDATE >= getdate())