SELECT ad_number, atex_ad_number, version_number, LOWER(LTRIM(careercast_ad_number, '0')) careercast_ad_number, price, bedrooms, bathrooms, sqfeet, company_name, address1, state, city, zip, area_code, phone, open, property_type(property_type, product_id) property_type, o_basement,o_carpet,o_deck,o_dishwasher,o_family_rm,o_fireplace, o_furnished,o_garage,o_hardwood,o_hot_tub,o_laundry,o_parking,o_vaulted, o_yard,o_washer_dryer,o_cats,o_dogs,o_withview,o_fsbo, email email_to, url u, o_photo, list_photo, list_photo_enabled, class_code, ad, ad_type, web_enhance, photo_hash from real_ad where ad_number = select zipname from zipcode_map where zipcode =
#realrent.address1#    #DollarFormat(realrent.price)#
#realrent.property_type#
Bedrooms:  #(realrent.bedrooms/100)#
Baths:  #(realrent.bathrooms/100)#
Property Type:  #realrent.property_type#
Calculate your mortgage
Amenities
#ReReplace(amen_list, "^,", "")#
Additional information
#realrent.ad#

-

more Photos nbmnbn
TOOLS
E-mail to a friend Map this property
Print this listing  
Contact this seller
Your name* agent image


broker logo
Your e-mail address*
Your phone
Best time to reach you
* Indicates required field