business_x_category.id,business.id,business.ts,business.business_name,business.home_page,business.email_address,business.phone,business.street,business.city,business.state,business.zip_code,business.full_address,business.category,business.rating,business.number_of_reviews,business.bbb_rating_or_license,business.latitude,business.longitude,business.cover_image,business.slogan,business.general_info,business.regular_hours,business.extra_phones,business.services_products,business.payment,business.price_range,business.aka,business.other_links,business.other_information,business.review_1_name,business.review_1_date,business.review_1_rating,business.review_1_text,business.review_2_name,business.review_2_date,business.review_2_rating,business.review_2_text
10047,3630,"2020-09-27 02:30:47","Violetz Goodies",,,"(215) 391-9707","Po Box 4436",Philadelphia,PA,19140,"Po Box 4436,Philadelphia,PA 19140","Modeling Agencies, Hair Stylists, Tailors",,,,40.011772,-75.14562,,,,"Mon - Sun: Open 24 Hours",,,"cash only",,,,,,,,,,,,
10271,3756,"2020-09-27 02:30:47","Long Island Models & Talent",http://www.longislandmodels.com,hello@longislandmodels.com,"(516) 712-7289","780 Long Beach Blvd","Long Beach",NY,11561,"780 Long Beach Blvd,Long Beach,NY 11561","Modeling Agencies, Advertising Specialties, Audio-Visual Production Services, Hair Stylists, Make-Up Artists, Talent Agencies",,,,40.5934,-73.65634,https://i3.ypcdn.com/blob/b454ed1e3e71b545124c992f6b3e1d4682e42593_100x100_crop.jpg?11da137,,,"Mon - Fri: 9:00 am - 6:00 pm Sat - Sun Closed",,,"all major credit cards, atm, check",,"Long Island Models",http://www.longislandmodels.com,,,,,,,,,
11248,4261,"2020-09-27 02:30:50","Bee GlamD LLC/The IAMB Agency",,theiambagency@yahoo.com,"(225) 319-5515","14150 Azalea Park Ave","Baton Rouge",LA,70816,"14150 Azalea Park Ave,Baton Rouge,LA 70816","Modeling Agencies, Hair Stylists, Make-Up Artists, Modeling Schools, Portrait Photographers",,,,30.45023,-91.02893,,,,,"Houston , Texas Office: (832) 559-0079",,,,,,,,,,,,,,
11579,4435,"2020-09-27 02:30:50","A&A Elite Management",,aaelitemanagement@gmail.com,"(904) 438-8604","P O Box 350243",Jacksonville,FL,32235,"P O Box 350243,Jacksonville,FL 32235","Modeling Agencies, Hair Stylists, Make-Up Artists, Photo Finishing, Video Production Services-Commercial",,,,30.110802,-81.60192,,"WE ARE THE TOTAL PACKAGE!",,"Mon - Fri: 10:00 am - 6:00 pm Sat: 10:00 am - 1:00 pm Sun Closed",,,,,,,,,,,,,,,
13804,5576,"2020-09-27 02:30:57","Styles by Vanessa",http://stylesbyvanessa.net,stylesbyvanessa33@gmail.com,"(818) 268-6049","11239 Ventura Blvd","Studio City",CA,91604,"11239 Ventura Blvd,Studio City,CA 91604","Modeling Agencies, Beauty Salons, Hair Stylists, Make-Up Artists, Women's Clothing",,,,34.14195,-118.37529,https://i3.ypcdn.com/blob/f040586990bddb5973a64648f2a4ca382d9f90fb_100x100_crop.jpg?11da137,"Change is always good","A bit about Miss Vanessa...Multi-talented, multi-tasking, and with a manner so warm and therapeutic that guests are reluctant to leave her chair, master stylist Vanessa brings over 15 years of experience to Salon Republic in Studio City. A truly dynamic designer, capable of conquering styles from simple to sublime with equal panache, Vanessa specializes in haircuts, highlights, color, extensions &? the Brazilian Blowout.","Mon - Fri: 10:00 am - 8:00 pm Sat: 10:00 am - 5:00 pm Sun Closed",,,"all major credit cards",,,"hair salon","Parking: Garage Bike Parking: Yes Wheelchair Accessible: Yes Price Range : Average",,,,,,,,
14940,6164,"2020-09-27 02:31:05","Opus Beauty",http://opusbeauty.com,info@opusbeauty.com,"(323) 856-8540","6442 Santa Monica Blvd Ste 200b","Los Angeles",CA,90038,"6442 Santa Monica Blvd Ste 200b,Los Angeles,CA 90038","Talent Agencies, Hair Stylists, Make-Up Artists",,,,34.09074,-118.33012,,,,"Mon - Fri: 9:30 am - 6:00 pm Sat - Sun Closed","Fax: (323) 856-8541",,,,,http://opusbeauty.com,,,,,,,,,
17182,7371,"2020-09-27 02:31:06","WB-Peter Lamas Beauty Products",,,"(347) 743-9367","419 Madison St Apt 1",Brooklyn,NY,11221,"419 Madison St Apt 1,Brooklyn,NY 11221","Modeling Schools, Beauty Salons, Cosmetic Services, Hair Stylists, Make-Up Artists",,,,40.68589,-73.94167,,,,,,,"paypal, check, all major credit cards",,,,,,,,,,,,
17405,7487,"2020-09-27 02:31:06","KLEWIS TALENT AGENCY",http://klewistalent.com,,"(404) 437-5581","260 Peachtree St NW",Atlanta,GA,30303,"260 Peachtree St NW,Atlanta,GA 30303","Artists Agents, Acting Schools & Workshops, Fashion Consultants, Hair Stylists, Talent Agencies",,,,33.76148,-84.38788,,,,"Mon - Fri: 7:00 am - 7:00 pm Sat - Sun: 10:00 am - 7:00 pm",,,"debit, paypal, cash, all major credit cards, travelers checks, visa",,,"Are You Our Next Talent Are You Our Next Talent!",,,,,,,,,
17571,7572,"2020-09-27 02:31:06","Fantasy Denise Make-Up Artistry",,fanfan5203@yahoo.com,"(817) 902-8195",,Arlington,TX,76017,"Arlington,TX 76017","Modeling Agencies, Hair Stylists, Make-Up Artists, Photography & Videography, Wedding Planning & Consultants",,,,,,,"I can only enhance the beauty you already possess!!","Waiting to make you feel more beautiful on your special day.",,,,,,,,,,,,,,,,
17577,7573,"2020-09-27 02:31:06","Impact Modeling & Talent Agency",http://www.theimpactagency.net,impactmodelingagency@gmail.com,"(504) 533-8759","Po Box 240815","New Orleans",LA,70184,"Po Box 240815,New Orleans,LA 70184","Modeling Agencies, Commercial Photographers, Hair Stylists, Make-Up Artists, Talent Agencies",5,"3 Reviews",,29.9544,-90.075,,"Anyone can be seen. but everyone can make an IMPACT!","We are a full service modeling and talent agency. We have a wide variety of talent from gorgeous models, awesome make-up artists to fabulous wardrobe stylists. Our company is based on the belief that our clients' needs are of the utmost importance. Our entire team is committed to meeting those needs. As a result, a high percentage of our business is from repeat clients and referrals. Our staff has over 30 years of experience in the industry. We would welcome the opportunity to earn your trust and deliver you the best service in the industry.","Mon - Sat: Open 24 Hours Sun Closed",,,"check, paypal, no credit cards",,,"Main Website",,tara.r.bingham,02/28/2013,five,"We love working with Impact. She keeps us informed with everything that is going on and the staff is so friendly.",tara.r.bingham,02/28/2013,five,
30231,12803,"2020-09-27 02:31:22","Accurate Psychic Readings",https://www.yellowpages.com/tulsa-ok/mip/accurate-psychic-readings-513276108?lid=1001637351756,,"(918) 260-8343","8164 S Elwood Ave",Tulsa,OK,74132,"8164 S Elwood Ave,Tulsa,OK 74132","Psychics & Mediums, Antiques, Beauty Salons, Cosmetic Services, Hair Stylists",,,,36.04345,-95.99662,https://i2.ypcdn.com/blob/8263f5a1acd24500773dc857c1de14b67f4f4711_100x100_crop.jpg?f9d23e1,,"This business offers Fortune Tellers and Psychic Mediums services. They also offer Salon services.",,,,,,"Frieda's Hair Salon Samurai Swords & Slot Machines","https://www.yellowpages.com/tulsa-ok/mip/accurate-psychic-readings-513276108 https://sales.yellowpages.com/tulsa-ok/mip/accurate-psychic-readings-513276108?lid=1001637351756",,,,,,,,,
75429,32670,"2020-09-27 02:32:55","West Lawn Service",,jonwildwildwest34@yahoo.com,"(757) 816-1779","119 Esplanade Pl",Chesapeake,VA,23320,"119 Esplanade Pl,Chesapeake,VA 23320","Landscaping & Lawn Services, Aircraft-Hangars-Rental & Sales, Banquet Halls & Reception Facilities, Bingo Halls, Builders Hardware, Chemical Storage & Handling, City Halls, Coffee Roasting & Handling Equipment, Computer Hardware & Supplies, Concert Halls, Dance Halls, Electrical Wire Harnesses, Fish Hatcheries, Garment Hangers, Gutters & Downspouts Cleaning, Hair Braiding, Hair Removal, Hair Removing Equipment & Supplies, Hair Replacement, Hair Stylists, Hair Supplies & Accessories, Hair Weaving, Halls, Auditoriums & Ballrooms, Hamburgers & Hot Dogs, Hammocks, Hand Painting & Decorating, Hand Tools, Handbags, Handbags-Wholesale & Manufacturers, Handwriting Analysts & Experts, Handyman Services, Hang Gliding & Instruction, Hardware Stores, Hardware-Wholesale & Manufacturers, Hardwood Floors, Hardwoods, Harvesting-Contract, Hat Shops, Hats-Wholesale & Manufacturers, Hawaiian Goods, Hawaiian Restaurants, Hay, Hay Rides, Hazardous Material Control & Removal, Hazardous Waste Engineers, Landscape Contractors, Livestock Hauling, Marine Hardware, Material Handling & Processing Engineers, Material Handling Equipment, Material Handling Equipment-Wholesale & Manufacturers, Oil Field Hauling, Oil Handling Equipment, Physicians & Surgeons, Hand Surgery, Picture Hanging Service, Pipe Hangers, Pool Halls, Poultry Hatcheries, Saddlery & Harness, Sand & Gravel Handling Equipment, Second Hand Dealers, Sexual Harassment Attorneys, Signs-Erectors & Hangers, Trash Hauling, Trucking-Heavy Hauling, Trucking-Light Hauling, Wallpaper Hanging Equipment & Supplies, Wigs & Hair Pieces",,,,36.73466,-76.26674,,,,"Mon - Sun: Open 24 Hours",,,,,,,,,,,,,,,
178570,59569,"2020-09-27 02:35:28",Ringsandmore.net,,,"(334) 796-4475","box 18",cowarts,AL,36321,"box 18,cowarts,AL 36321","Gold, Silver & Platinum Buyers & Dealers, Hair Stylists, Hair Supplies & Accessories, Jewelry Supply Wholesalers & Manufacturers, Online & Mail Order Shopping",,,,,,,"Quality products at a fair price.","We sell brand name quality products.",,,,,,,,,,,,,,,,
203084,67693,"2020-09-27 02:36:03","Live Wire Salon & Boutique",,ezon86@rocketmail.com,"(401) 218-2253","99 Fortin Rd Ste 135",Kingston,RI,02881,"99 Fortin Rd Ste 135,Kingston,RI 02881","Clothing Stores, Boutique Items, Hair Stylists, Tailors",,,,41.48524,-71.52316,,,"We offer unique clothing & accessories and one-of-a-kind hand made items as well as pre-owned clothing and accessories. We also have a hair studio (call for appointment) and offer expert tailoring and alterations (by appointment). Located next to Cumberland Farms at the URI Emporium. We have new items arriving weekly.","Mon: 11:00 am - 5:00 pm Tue: 5:00 am - 8:00 pm Wed: 11:00 am - 5:00 pm Thu: 5:00 pm - 8:00 pm Fri: 12:00 pm - 5:00 pm Sat: 1:00 am - 5:00 pm","for fittings / tailoring: (401) 787-3354",,"debit, check, cash, all major credit cards",,,,,,,,,,,,
246914,81259,"2020-09-27 02:37:35","Makeup Glitz",http://www.makeupglitz.com,shaziimakeupglitz@gmail.com,"(407) 473-5357","4870 S Apopka Vineland Rd",Orlando,FL,32819,"4870 S Apopka Vineland Rd,Orlando,FL 32819","Make-Up Artists, Bridal Registries, Floor Waxing, Polishing & Cleaning, Hair Stylists, Party & Event Planners, Permanent Make-Up",,,,28.48974,-81.50866,https://i3.ypcdn.com/blob/7cf808165529b81e66ae8e35812954a93c8a5328_100x100_crop.jpg?f9d23e1,MakeupGlitz,"I'm a Professional Make-up Artist, Hair Designer & Stylist as well as Henna/Mehndi Artist located in Orlando, Florida. I specialized in make-up, hair design and styling & Henna/Mehndi services on location for weddings, photo shoots, film, T.V, editorial, commercial & special events. so please email or ph call for your inquiry....Thank you! Ph: (407)473-5357 www.makeupglitz.com","Mon - Sun: 8:00 am - 12:00 am",,,"cash only",,,http://www.makeupglitz.com,,,,,,,,,
247640,81491,"2020-09-27 02:37:35","Medical Skin Care",http://www.wyoskindoc.com,,"(307) 215-1281","2546 E 2nd St Ste 400",Casper,WY,82609,"2546 E 2nd St Ste 400,Casper,WY 82609","Bridal Shops, Beauty Salons, Formal Wear Rental & Sales, Hair Stylists, Hair Weaving, Nail Salons, Physicians & Surgeons, Cosmetic Surgery, Wedding Supplies & Services",,,,42.84916,-106.29308,https://i2.ypcdn.com/blob/cf0dc976b964a2f22f3e749e522113b0f39df31f_100x100_crop.jpg?e66d351,"Dr Scott Benion.","At Medical Skin Care we offer the latest in skin care treatments, state of the art technology in a modern and private facility, a professional staff, and all operating under the direct supervision of Dr. Scott Bennion. At Medical Skin Care, we are your total skin care professionals.","Mon - Sat: 8:00 am - 5:00 pm Sun Closed",,,"all major credit cards",,,"http://www.wyoskindoc.com http://facebook.com","Wheelchair Accessible: Yes Parking: Lot, Free",,,,,,,,
247694,81504,"2020-09-27 02:37:35","Rafi salonandspa",,,"(718) 676-0851","715 Avenue U",Brooklyn,NY,11223,"715 Avenue U,Brooklyn,NY 11223","Bridal Shops, Beauty Salons, Hair Stylists, Nail Salons",,,,40.59817,-73.96355,,,,,,,,,,,,,,,,,,,
247832,81551,"2020-09-27 02:37:35","Beaute by Daisy",http://www.beautebydaisy.weebly.com,beautebydaisy@aol.com,"(602) 489-8838","7018 E Camelback Rd",Scottsdale,AZ,85251,"7018 E Camelback Rd,Scottsdale,AZ 85251","Bridal Shops, Beauty Salons, Hair Stylists, Make-Up Artists, Party & Event Planners",,,,33.5024,-111.92885,https://i2.ypcdn.com/blob/6cb6cd0f9856ef145ad2949efb5f2dff0c30ff9a_100x100_crop.jpg?e66d351,"All things makeup and beauty.","All things beauty.","Mon - Fri: 8:30 am - 7:00 pm Sat - Sun: 7:30 am - 5:00 pm",,,"cash, all major credit cards",,,http://www.beautebydaisy.weebly.com,,,,,,,,,
247917,81581,"2020-09-27 02:37:35","Miami Wrap Spa",,,"(754) 200-5641","230 NE 38th St","Oakland Park",FL,33334,"230 NE 38th St,Oakland Park,FL 33334","Bridal Shops, Fashion Consultants, Hair Stylists, Nail Salons, Reducing & Weight Control",,,,26.17396,-80.14341,,,,"Mon - Thu: 9:00 am - 10:00 pm Fri: 9:00 am - 8:00 pm Sat: 8:00 am - 8:00 pm Sun: 9:00 am - 2:00 pm",,,,,,,,,,,,,,,
248212,81668,"2020-09-27 02:37:35","Snips SpaSalon",http://snips.com,malyoung@hotmail.com,"(612) 567-4419","5147 W 98th St",Minneapolis,MN,55437,"5147 W 98th St,Minneapolis,MN 55437","Bridal Shops, Beauty Salons, Cosmetic Services, Hair Stylists, Make-Up Artists, Nail Salons, Wedding Supplies & Services","4,5","4 Reviews",A+,44.82538,-93.34715,https://i2.ypcdn.com/blob/b51a4b9ccf832ad4a82e8a6e8f65a505f90a8236_100x100_crop.jpg?e66d351,"One stop salon for all your pampering needs!","Our goal is to meet your service needs with the highest quality service. We also offer full massage and esthetic services. Our spa professionals will relieve your aches and pains, help heal & treat your skin, and provide full body waxing services. We guarantee that you will feel renewed and refreshed. Call us today for more information!","Mon - Thu: 9:00 am - 9:00 pm Fri: 9:00 am - 8:00 pm Sat: 8:00 am - 5:00 pm Sun: 11:00 am - 5:00 pm",,,"cash, check, all major credit cards, amex, debit, discover, master card, visa",,,http://snips.com,"Parking: Lot Wheelchair Accessible: Yes Price Range : Average By Appointment Only: No",armywifejb,05/20/2011,five,"Snips is a wonderful, relaxing well run salon. Every time I go there I feel as though I am family. The front desk staff is always welcoming and caring, the service providers are well educated and listen to your needs. I have been seeing Bart for a while and LOVE him! He does amazing work and always makes me feel wonderful. Liz, a new service provider is the best shampooer in the world. I have also seen Jill & Kimberly for nails. Wonderful ladies. All of the team at SNIPS are well educated and really listen to your needs! If you join there text message club you get great specials. I also take my 4 yr old daughter there. Mr Bart helped us grow out a haircut that she gave herself. Now she loves to come see Mr. Bart. Love it!!! Try it, you'll love it too. PS they also have an amazing referral program!!",shmeak,08/02/2007,five,"Loved it. I had a full spa day and it was very reasonalble in price. My favorite was the Pedicure. I also got my hair cut and am going back next week to get a highlight- I can't wait!"
248216,81669,"2020-09-27 02:37:35","Maven Hair Company",http://www.mavenhaircompany.com,Support@Mavenhaircompany.Com,"(508) 528-6286","56 E Central St",Franklin,MA,02038,"56 E Central St,Franklin,MA 02038","Hair Stylists, Beauty Salons, Bridal Shops, Hair Removal, Make-Up Artists",,,A+,42.08197,-71.39442,https://i2.ypcdn.com/blob/3b7eb26ca456b0092af00b93ba85d6a1e5672af2_100x100_crop.jpg?f9d23e1,,,"Tue: 10:00 am - 8:00 pm Wed: 1:00 pm - 8:00 pm Thu: 10:00 am - 8:00 pm Fri: 10:00 am - 6:00 pm Sat: 9:00 am - 5:00 pm",,,amex,,"Maven Hair Co",http://www.mavenhaircompany.com,"Parking: Street",,,,,,,,
248723,81842,"2020-09-27 02:37:36","The Nail Boutique & Beauty Salon",http://www.nailboutiqueandbeautysalon.com,shelleymarceline@gmail.com,"(928) 526-3002","2724 E Lakin Dr",Flagstaff,AZ,86004,"2724 E Lakin Dr,Flagstaff,AZ 86004","Bridal Shops, Beauty Salons, Cosmetic Services, Formal Wear Rental & Sales, Hair Removal, Hair Stylists, Hair Weaving, Nail Salons, Wedding Supplies & Services",,,,35.21127,-111.60648,,"Full service hair design","Full service hair design The Nail Boutique and Beauty Salon takes care of your beauty needs from head to toe! We'll help you get the look you want. The Nail Boutique and Beauty Salon has been customizing your look for over 30 years. We believe in treating our clients right, giving them prompt service and personalized attention. We offer a full range of services that included: Manicures Pedicures Spa dips Custom blended foundation/Cosmetics Brow shaping Lash/Brow Tinting Facial waxing Come by and let us customize your look today.","Tue - Sat: 9:00 am - 5:00 pm",,,"amex, discover, visa, master card, cash, check",,,http://www.nailboutiqueandbeautysalon.com/,,,,,,,,,
248952,81932,"2020-09-27 02:37:36","Prism Blow Dry Bar & Eyelash Studio",,,"(631) 250-9358","425 Lake Ave","Saint James",NY,11780,"425 Lake Ave,Saint James,NY 11780","Hair Braiding, Beauty Salons, Bridal Shops, Hair Stylists, Make-Up Artists",,,,40.88118,-73.1568,,,,,,,,,,,,,,,,,,,
249726,82183,"2020-09-27 02:37:40","Bella Vita Salon & Day Spa",http://www.bellavitanorthandover.com,jcunhabv@yahoo.com,"(978) 682-5103","1019 Osgood St","North Andover",MA,01845,"1019 Osgood St,North Andover,MA 01845","Day Spas, Beauty Salons, Bridal Shops, Hair Removal, Hair Stylists, Hair Supplies & Accessories, Make-Up Artists, Massage Services, Massage Therapists, Medical Spas, Nail Salons, Skin Care",5,"19 Reviews",A+,42.71461,-71.11644,https://i2.ypcdn.com/blob/1e3ada7e48328426cd7576acb729e4ad41ef22e0_100x100_crop.jpg?f9d23e1,"Salon. Day Spa. MediSpa",,"Mon Closed Tue - Thu: 8:30 am - 8:00 pm Fri: 8:30 am - 7:00 pm Sat: 8:00 am - 4:00 pm Sun Closed Holiday Hours 2020/09/07 Closed",,,"discover, visa, amex, cash, check, debit, mastercard",,,http://www.bellavitanorthandover.com,"Parking: Lot, Private Bike Parking: Yes Wheelchair Accessible: Yes Price Range : Average By Appointment Only: Yes","Mariah H.",09/09/2014,five,"I have enjoyed your spa monthly for years. And I hope to continue for years to come. I am always greeted warmly. Service is prompt but never rushed. I love the atmosphere of calm. Your spa is quiet and soothing to my soul Thank you so much. I always look forward to my appointments in my busy life!!!","Betty P.",08/25/2014,five,"Mariel & Rachel are AWESOME!!!! I dropped my mother off on Saturday for a cut/color/style and a facial. When I picked her up she looked amazing.. Her skin had a glow, and her hair was gorgeous!!!"
250310,82363,"2020-09-27 02:37:40","Unique and Flawless",https://www.theknot.com/marketplace/unique-and-flawless-oceanside-ca-873995,,"(760) 978-1652","1551 union st","San Diego",CA,92101,"1551 union st,San Diego,CA 92101","Bridal Shops, Cosmetics & Perfumes, Cosmetologists, Hair Stylists, Make-Up Artists",,,,32.72162,-117.16532,,,,"Mon - Sun: 8:00 am - 6:00 pm",,,"visa, discover, mastercard, all major credit cards, check, debit, paypal",,,https://www.theknot.com/marketplace/unique-and-flawless-oceanside-ca-873995,,,,,,,,,
250982,82557,"2020-09-27 02:37:40","Ardsley Salon",http://www.ardsleysalon.com,,"(914) 231-7211","466 Ashford Ave",Ardsley,NY,10502,"466 Ashford Ave,Ardsley,NY 10502","Bridal Shops, Beauty Salons, Hair Removal, Hair Stylists, Nail Salons",,,,41.01171,-73.84864,,,,"Mon Closed Tue - Wed: 9:30 am - 5:00 pm Thu: 10:00 am - 7:00 pm Fri: 9:30 am - 5:00 pm Sat: 9:00 am - 5:00 pm Sun Closed",,,"visa, master card, amex, debit, check",,,"web page",,,,,,,,,
251165,82615,"2020-09-27 02:37:40","Beauty & Brides By Sonia",,soniaabboud27@gmail.com,"(704) 332-5763","2028 E 7th St",Charlotte,NC,28204,"2028 E 7th St,Charlotte,NC 28204","Bridal Shops, Beauty Salons, Hair Stylists, Wedding Supplies & Services, Welcome Service",5,"4 Reviews",,35.21149,-80.81744,https://i2.ypcdn.com/blob/e9fd34726fb23cbbd86e83e42f8535619f29425c_100x100_crop.jpg?f9d23e1,,,"Mon - Thu: 11:00 am - 6:00 pm Fri: 11:00 am - 3:00 pm Sat - Sun Closed",,,"master card, amex, carte blanche, company card, diners club, discover, jcb, visa, all major credit cards, check",,,,,wburton4,03/06/2013,five,"I have been going to Sonia for years and have never been disappointed. She is the only person I trust with my hair. She does a phenomenal job every time!!",vieiramatheson,11/14/2012,five,"Sonia is an exceptionally talented hairdresser who excels at color and styling. She is very innovative and does her best to please you. After she is finished with your hair you walk out of her salon feeling wonderful. I get a lot of compliments on my hair because of Sonia. Thanks Sonia"
252146,82936,"2020-09-27 02:37:40","Khinky Chic Hair",http://www.khinky.com,info@khinky.com,"(646) 504-0636","Independence Ave",Bronx,NY,10463,"Independence Ave,Bronx,NY 10463","Hair Braiding, Bridal Shops, Hair Stylists, Hair Weaving, Wigs & Hair Pieces",,,,40.88526,-73.91547,,,,,"MobilePhone: (646) 504-0636",,"discover, amex, mastercard, visa",,,"Dreadlock Extensions Virgin Human Hair Imports",,,,,,,,,
252843,83163,"2020-09-27 02:37:51","Se Jolie Bridal & Formal Outlet",http://www.bridalprompageant.com,simonesunlimited@gmail.com,"(717) 634-2274","947 Carlisle St",Hanover,PA,17331,"947 Carlisle St,Hanover,PA 17331","Bridal Shops, Bridal Gown Preservation, Bridal Supplies-Wholesale & Manufacturers, Day Spas, Hair Stylists",,,,39.81479,-76.99217,,,,"Mon - Fri: 10:00 am - 8:00 pm Sat: 9:00 am - 3:00 pm Sun Closed",,,"all major credit cards, check, debit",,,"Bridal Shop and Outlet store",,,,,,,,,
254524,83690,"2020-09-27 02:37:51","Fantasy Wedding Hair and Makeup",http://www.fantasyhairandmakeup.com,,"(478) 290-5163","229 Circle Dr","Saint Simons Island",GA,31522,"229 Circle Dr,Saint Simons Island,GA 31522","Bridal Shops, Beauty Salons, Hair Stylists, Make-Up Artists, Wedding Supplies & Services",,,,31.16121,-81.38572,,,,,,,,,,"Fantasy Wedding Hair and Airbrush Makeup",,,,,,,,,
255704,84063,"2020-09-27 02:38:02","A Affordable Hair",http://m.citysearch.com/profile/1719469/sun_city_west_az/a_affordable_hair.html,aaffordablehairnail@gmail.com,"(623) 584-8399","13930 W Camino Del Sol","Sun City West",AZ,85375,"13930 W Camino Del Sol,Sun City West,AZ 85375","Bridal Shops, Beauty Salons, Beauty Salons-Equipment & Supplies-Wholesale & Manufacturers, Cosmetic Services, Formal Wear Rental & Sales, Hair Removal, Hair Stylists, Hair Weaving, Nail Salons, Wedding Supplies & Services",,,,33.65833,-112.36143,https://i2.ypcdn.com/blob/563c76d8aa8c8140b44d1bc82618bd6cfcc8302b_100x100_crop.jpg?f9d23e1,"Life Isn't Perfect, But Your Hair Can Be.","A Affordable hair has been serving the valley for over 30 years! We are a family owned, full-service Salon. Our services include: Hair cuts, Coloring, Nails, Facials, Waxing. Call today to schedule an appointment!","Mon - Sat: 8:00 am - 5:00 pm Sun Closed",,,"cash only",,,http://m.citysearch.com/profile/1719469/sun_city_west_az/a_affordable_hair.html,"Wheelchair Accessible: Yes",,,,,,,,
257528,84625,"2020-09-27 02:38:02","Renaissance Salon & Spa",http://renaissancespasalon.com,kasenzimm@yahoo.com,"(406) 656-6400","2406 Broadwater Ave",Billings,MT,59102,"2406 Broadwater Ave,Billings,MT 59102","Bridal Shops, Beauty Salons, Cosmetic Services, Formal Wear Rental & Sales, Hair Stylists, Hair Weaving, Hotels, Nail Salons, Wedding Supplies & Services",,,,45.77678,-108.57714,https://i2.ypcdn.com/blob/2b0e767002cf74b26e71c7cc098e693382863cc4_100x100_crop.jpg?e66d351,"We Love Color and So Will You.","Welcome to Renaissance Salon & Spa where we are celebrating over 10 years as one of the main salons in Billings, Montana. Come in and see what sets us apart. We offer a full are a full service hair and nail salon to help you look and feel your best. the licensed specialists at Renaissance Salon & Spa give each client the individual attention necessary for great results every time. Our services include: В• Cuts В• Coloring В• Perms В• Formal styles В• Manicures & pedicures В• Acrylic nails В• Waxing Renaissance Salon & Spa is locally owned and operated by stylist LeAnne Tibesar. She will make sure that you leave her salon looking and feeling your best. Call and make an appointment today!","Mon: 9:00 am - 6:00 pm Tue: 9:00 am - 8:00 pm Wed - Fri: 9:00 am - 6:00 pm Sat: 9:00 am - 5:00 pm Sun Closed",,,"amex, discover, visa, master card",,,http://renaissancespasalon.com,"Parking: Lot, Private Wheelchair Accessible: Yes Price Range : Above Average By Appointment Only: No",,,,,,,,
257573,84637,"2020-09-27 02:38:02","Nails & Hair",http://www.attitudezhairandnails.com,,"(303) 678-0003","2255 Main St",Longmont,CO,80501,"2255 Main St,Longmont,CO 80501","Bridal Shops, Beauty Salons, Cosmetic Services, Formal Wear Rental & Sales, Hair Stylists, Hair Weaving, Make-Up Artists, Nail Salons, Wedding Supplies & Services",5,"1 Review",,40.1977,-105.10295,,"We Have Great Stylists.","When your hair is down and out, and your nails are broken and bland, Nails and Hair is the place to visit. Serving the Longmont area, and located right on Main Street, we provide a comfortable and relaxing atmosphere for you get your hair and nails done. We are reliable to keeping our appointments, with very affordable prices. Our complete nail service keeps our customers very happy! Come enjoy the experience. We provide friendly service, and product that you're looking for. Call us today and make an appointment!","Mon - Fri: 8:00 am - 6:30 pm Sat: 8:00 am - 4:00 pm",,,"mastercard, all major credit cards, debit, amex, discover, check, visa",,,http://www.attitudezhairandnails.com,"Parking: Self, On Site, Free Wheelchair Accessible: Yes",kathy.lovenburg,05/22/2013,five,"Great place to go for a basic mani/pedi. Nancy was very friendly, knowledgable, and fun to talk to! Prices reasonable, easy parking. I will come back!!",,,,
257616,84648,"2020-09-27 02:38:02","Toni's Beauty on the Move",,Tonisbeautyonthemove@gmail.com,"(561) 891-0880",,highlands,NJ,07732,"highlands,NJ 07732","Bridal Shops, Beauty Salons, Day Spas, Hair Stylists, Nail Salons",,,,,,,"Bringing beauty to you!",,,,,"check, no credit cards",,,,,,,,,,,,
258015,84777,"2020-09-27 02:38:02","Hair By Amal Salon & Boutique WOMEN ONLY",,Hairbyamal@hotmail.com,"(313) 914-2858","5030 Schaefer Rd",Dearborn,MI,48126,"5030 Schaefer Rd,Dearborn,MI 48126","Bridal Shops, Hair Stylists, Make-Up Artists, Nail Salons",,,,42.32443,-83.17591,https://i2.ypcdn.com/blob/dc46e92f0aefd05c4d09742933ef249eace05a6a_100x100_crop.jpg?f9d23e1,,,"Mon: 11:00 am - 7:00 pm Tue Closed Wed - Thu: 11:00 am - 7:00 pm Fri - Sat: 10:00 am - 7:00 pm Sun: 10:00 am - 6:00 pm","TollFree: (313) 914-2858",,"debit, cash, all major credit cards",,,,,,,,,,,,
258777,85034,"2020-09-27 02:38:13","Salon George",http://www.salongeorgestpaul.com,pgeorgehair@aol.com,"(651) 346-3722","856 Raymond Ave","Saint Paul",MN,55114,"856 Raymond Ave,Saint Paul,MN 55114","Bridal Shops, Beauty Salons, Cosmetic Services, Formal Wear Rental & Sales, Hair Stylists, Hair Weaving, Make-Up Artists, Nail Salons, Wedding Supplies & Services",4,"6 Reviews",,44.96711,-93.19743,https://i2.ypcdn.com/blob/bf4ade982ffdfcc61cb2f15e54c559c89dbfed2e_100x100_crop.jpg?e66d351,"2007 national salon of the year distinction award winner. (Salon Today Magazine)","2007 national salon of the year distinction award winner. (Salon Today Magazine) Salongeorge is a full service Salonspa & Art Gallery. An upscale urban salon with a small family business feel We offer a warm & welcoming environment that gives our clients the gift of beauty & rejuvenation We carry PureOlogy, Moraccanoil, Label.m, Dermalogica, Smashbox makeup, & OPI products. Hair Services Hair Extensions Special Occasion Hair and Makeup Massage Therapy Spa & Facials Waxing Nail Services We offer a wonderful assortment of gifts for you & those important in your life by providing an avenue for local artisans. Shop our boutique Come & experience Salongeorge - Rejuvenate you Call now.","Mon: 12:00 pm - 7:00 pm Tue - Thu: 9:00 am - 8:00 pm Fri: 9:00 am - 7:00 pm Sat: 9:00 am - 4:00 pm Sun Closed",,,"debit, amex, all major credit cards",,,http://www.salongeorgestpaul.com,"Parking: Free Wheelchair Accessible: Yes By Appointment Only: Yes",angie521,01/06/2009,five,"My stylist moved to Salon George and the place is just fantastic. It is beautiful inside and I could not be happier. My stylist is the best in the business and I can't say enough good things about her. I would never go anywhere else but Salon George.",jesslh,11/21/2008,five,"I rate this place a WOW. As a first-time client, I took the always scary """"luck of the draw"""" hairstylist, and ended up with an amazing cut. The customer service was superb, and the atmosphere was inviting and cool as heck. To top it off, it was a great value for the luxurious treatment. I will be going back--in fact I plan to make it a habit. Located near the U, north of University a block or two, on Raymond."
258990,85105,"2020-09-27 02:38:13","Twilight Crystal Spa",,twilightcrystalspa@gmail.com,"(515) 344-3076","123 NW 2nd St","Des Moines",IA,50313,"123 NW 2nd St,Des Moines,IA 50313","Bridal Shops, Beauty Salons, Hair Stylists, Make-Up Artists, Massage Therapists",,,,41.62016,-93.61913,,"Bring out the rockstar or beauty queen out in you.",,"Mon - Sun: Open 24 Hours",,,"debit, all major credit cards",,,,,,,,,,,,
259101,85139,"2020-09-27 02:38:13","Bridal Beauty Associates, LLC",http://www.bridalbeautytogo.com,info@bridalbeautytogo.com,"(888) 511-7138","914 Silver Spring Ave","Silver Spring",MD,20910,"914 Silver Spring Ave,Silver Spring,MD 20910","Bridal Shops, Cosmetologists, Hair Stylists, Make-Up Artists, Wedding Supplies-Wholesale & Manufacturers",,,,38.99139,-77.02555,,,,,,,"all major credit cards",,,http://www.bridalbeautytogo.com,,,,,,,,,
260064,85450,"2020-09-27 02:38:13","A NOLA BRIDE",,,"(504) 496-1003","2705 N Sibley St",metairie,LA,70003,"2705 N Sibley St,metairie,LA 70003","Bridal Shops, Beauty Salons, Cosmetologists, Hair Stylists, Wedding Supplies & Services",,,,30.00126,-90.22138,,,,"Mon - Fri: 10:00 am - 7:00 pm Sat: 8:00 am - 8:00 pm Sun Closed","504 469-0617: (504) 908-4885",,"check, cash",,,,,,,,,,,,
261462,85880,"2020-09-27 02:38:13",Mytypeofmakeup,http://www.mytypeofmakeup.com,maha@mytypeofmakeup.com,"(678) 993-8804","2100 Shiloh Valley Dr NW",Kennesaw,GA,30144,"2100 Shiloh Valley Dr NW,Kennesaw,GA 30144","Indian Goods, Beauty Schools, Bridal Registries, Hair Stylists, Make-Up Artists, Wedding Supplies & Services",,,,34.00323,-84.5659,https://i2.ypcdn.com/blob/e5338d406134bc94ef3df18d503f34ba543e06ba_100x100_crop.jpg?f9d23e1,,"Makeup Artist Maha Karim specializes in Bridal, Occasional, Runway and Photo/Film makeup. She also styles hair for all events. Mytypeofmakeup is Mahas personal touch of glam on her clients that make her work authentic. Reach out to her at maha@mytypeofmakeup.com for details on her services. You can also visit her at www.mytypeofmakeup.com to check out her work and learn more about the artist.","Mon - Sun: 8:00 am - 7:00 pm",,,"paypal, visa, discover, mastercard, all major credit cards",,,http://www.mytypeofmakeup.com,,,,,,,,,
262289,86129,"2020-09-27 02:38:20","Colorado Makeup and Hair",http://www.coloradomakeupandhair.com,,"(954) 882-3593","3345 Chisholm Trl",Boulder,CO,80301,"3345 Chisholm Trl,Boulder,CO 80301","Bridal Shops, Hair Stylists, Make-Up Artists, Wedding Photography & Videography, Wedding Planning & Consultants",,,,40.03579,-105.25201,,"Specializing in ""The Total Beauty Transformation""","Bridal Hair and Makeup Team","Mon - Sun: 9:00 am - 6:00 pm",,,"check, cash, all major credit cards",,,"Bridal Makeup and Hair Team",,,,,,,,,
262532,86211,"2020-09-27 02:38:20","The Parlor Hair Stylists",http://www.parlorhairsalon.com,,"(763) 425-5771","213 Central Ave",Osseo,MN,55369,"213 Central Ave,Osseo,MN 55369","Bridal Shops, Beauty Salons, Cosmetic Services, Formal Wear Rental & Sales, Hair Stylists, Hair Weaving, Make-Up Artists, Nail Salons, Wedding Supplies & Services",,,,45.11853,-93.40259,,"Let Our Stylists Enhance Your Natural Beauty.","The Parlor Hair Stylists in Osseo, Minnesota, are eager to help enhance your natural beauty. Our expertly trained stylists have experience cutting and styling hair for everyday and special occasions. Our services include haircuts, styling, and coloring. Our goal is to exceed your expectations with every service. We can take you from drab to fab with a cute cut and style or give you the ultimate in flair with a bold new hair color. Call us today to schedule an appointment.","Mon Closed Tue: 8:00 am - 7:00 pm Wed: 11:00 am - 7:00 pm Thu: 8:00 am - 7:00 pm Fri: 8:00 am - 3:00 pm Sat: 8:00 am - 2:00 pm Sun: 9:00 am - 2:00 pm",,,"all major credit cards, mastercard, visa, discover, amex",,,http://www.parlorhairsalon.com,"Parking: Lot, Free Wheelchair Accessible: Yes Price Range : Average By Appointment Only: Yes",,,,,,,,
262569,86220,"2020-09-27 02:38:20","Bella Hair Design",,albenehoff12@gmail.com,"(541) 666-1561","1115 Santiam Hwy. SE",Albany,OR,97321,"1115 Santiam Hwy. SE,Albany,OR 97321","Bridal Shops, Barbers, Beauty Salons, Cosmetic Services, Hair Braiding, Hair Stylists, Hair Weaving, Nail Salons, Wedding Supplies & Services",4,"2 Reviews",,44.636684,-123.09148,https://i2.ypcdn.com/blob/f1fc1a789ac975abc0219e05239438ee6ead1794_100x100_crop.jpg?e66d351,"Providing a variety of hair salon services to customers throughout Albany.","Providing a variety of hair salon services to customers throughout Albany. Whether youre looking for a clean cut before an interview or elaborate design for a wedding, were the people for you. Our experienced stylists do everything from razor cuts to weaves. We also offer spa manicures and pedicures, so let us be your one-stop shop for all of your salon needs! Learn More About Bella Hair Design: Cuts and styles, Weddings and proms, Razor cuts, Balayage, Extensions, Perms Corrective color Weaves, Waxing, Spa manicures and pedicures, Brazillian Blowouts. We specialize in customer service, which means you are sure to be satisfied with your hair. Contact Bella Hair Design today!","Tue - Sat: 9:00 am - 7:00 pm",,,"master card, visa, cash, check, debit",,,,"Parking: Lot","Amy E.",12/18/2015,three,"The 5419282312 number is disconnected. Tried the call the main number and got an answering machine. Do I have to make an apointment? I may never know...",portia46,05/27/2008,five,"Wow! A lovely classy salon right here in Albany. I came upon the owner, Libby Hunt, when my original stylist changed occupations. Libby worked out of the same salon and I had heard how good she was so I made an appointment. Only to find that Libby and one of her colleagues had designed and opened a new salon right here in Albany. I've discovered that Libby is the greatest stylist in Albany and could easily give any stylist in a metropolitan area a run for their money, but I've heard the other stylists there are wonderful as well. The salon is very chic classy and relaxed. And, the prices are reasonable. If you're new in town or just ready to change stylists, you will be in very good hands at Bella Hair Design. Three Cheers For Libby!!! Most Sincerely, Wendy Hull"
263682,86577,"2020-09-27 02:38:20","Queens Parlour Cosmetology Sln",http://queensparlour.com,,"(309) 797-1160","171 19th Ave",Moline,IL,61265,"171 19th Ave,Moline,IL 61265","Bridal Shops, Beauty Salons, Formal Wear Rental & Sales, Hair Removal, Hair Stylists, Nail Salons, Personal Services & Assistants, Personal Shopping Service, Wedding Supplies & Services",,,A+,41.49357,-90.53486,,"Creative Hair Care.","Queen's Parlour has been making people beautiful in Moline for over 45 years. We have been a leading cosmetology salon specializing in cut, color and curls. Our stylists will help you find a style that will fit your lifestyle and face shape. Our services include: В• Razor cuts В• Italian color В• Perming В• Deep conditioning В• Highlights В• Waxing В• Non-invasive face peel В• Men and children Queen's Parlour offers their clients the latest style trends in hair cutting and coloring. We do event hair for proms and weddings. You can trust your hair to our experienced stylists and know you will come out looking great. Call Queen's Parlour today to schedule an appointment.","Mon Closed Tue - Fri: 9:00 am - 6:00 pm Sat - Sun Closed",,,"cash, master card",,,http://queensparlour.com,"Parking: Lot",,,,,,,,
264006,86687,"2020-09-27 02:38:20","The Boulevard Hair Co",https://salonblvd.com,reservations@salonblvd.com,"(314) 733-5488","8193 Big Bend Blvd","Webster Groves",MO,63119,"8193 Big Bend Blvd,Webster Groves,MO 63119","Hair Stylists, Barbers, Beauty Salons, Bridal Shops, Day Spas, Hair Braiding, Hair Removal, Hair Supplies & Accessories, Hair Weaving, Make-Up Artists, Wedding Supplies & Services",,,,38.59132,-90.34024,https://i2.ypcdn.com/blob/dcb9559b2550c6cdf41094bddd59ced5f4a09d67_100x100_crop.jpg?f9d23e1,"""Reclaim Your Beauty""",,"Mon - Thu: 8:30 am - 9:00 pm Fri: 9:00 am - 4:00 pm Sat: 8:00 am - 4:00 pm Sun Closed",,,"visa, mastercard, amex, discover, apple pay, check, cash, all major credit cards",,,"Primary Website",,,,,,,,,
264877,86963,"2020-09-27 02:38:20","BEYOND STUDIO",http://beyondstudiousa.com,,"(571) 535-1640","13885 Hedgewood Dr",Woodbridge,VA,22193,"13885 Hedgewood Dr,Woodbridge,VA 22193","Bridal Shops, Beauty Salons, Hair Stylists, Make-Up Artists, Photography & Videography",,,,38.65164,-77.31683,https://i2.ypcdn.com/blob/eea34fee03ade75f025a039d7a1cc33da6574612_100x100_crop.jpg?f9d23e1,"never good enough","we create colors and cuts that bring out your best features and compliments your personality. He is dedicated to continuously developing and advancing his skills through education and training, and holds several certifications as color specialist for leading haircolor brands, as well as masters estetician and cosmotolegy licenses.","Mon - Sun: 10:00 am - 8:00 pm",,,"all major credit cards, cash, check, debit, visa",,,http://beyondstudiousa.com,"Parking: Lot, Free Bike Parking: Yes Wheelchair Accessible: Yes",,,,,,,,
265332,87116,"2020-09-27 02:38:24","The Brides Finishing Touch",,,"(941) 706-7057","2131 Siesta dr",Sarasota,FL,34239,"2131 Siesta dr,Sarasota,FL 34239","Bridal Shops, Beauty Salons, Hair Stylists, Make-Up Artists, Nail Salons",,,,27.30323,-82.52755,,"A Look For That Very Special Day","On Location or in the Salon at The Brides Finishing Touch we make every effort to see that the bride and her attendants will have that once in a life time hair style and makeup experience for that blessed day. Our hair and makeup teams work with only one wedding per day under the direction of Lori so the bride and her party gets the hair and make-up they will cherish in photos for a life time. When planning for a wedding small things that are a big part of the Bridal Party's hair style and makeup are sometimes over looked such as hair color or highlights. At The Brides Finishing Touch we make every effort to suggest and offer services and products that are sometimes only associated with a regular trip to the salon but play a big part in style and makeup on this special occasion.","Mon - Fri: 9:00 am - 4:00 pm Sat Closed","Phone: (941) 400-0953",,"all major credit cards, check, debit",,,,,,,,,,,,
265387,87134,"2020-09-27 02:38:24","Guys & Gals Quarters Salon & Day Spa",http://www.guysandgalsquarters.com,ggqsalon@gmail.com,"(812) 934-2544","22 Saratoga Dr",Batesville,IN,47006,"22 Saratoga Dr,Batesville,IN 47006","Nail Salons, Beauty Salons, Bridal Shops, Day Spas, Hair Stylists, Make-Up Artists, Massage Services, Massage Therapists, Skin Care, Tanning Salons",,,,39.31265,-85.2124,,"Everyday to Runway","Guys & Gals Quarters originated in 1977 in Oldenburg, Indiana and approximately 10 years later opened a second location in Batesville, Indiana. Tamara Lamping, Guys & Gals owner has been one of the reasons for the salons success. Tamara's drive and passion for the industry evolved the hair salon into Guys & Gals Quarters Salon & Day Spa in 1998. For Tamara it's not about just getting a great haircut or spa treatment but it's about the whole salon experience.","Mon: 9:00 am - 6:00 pm Tue - Thu: 9:00 am - 8:00 pm Fri: 9:00 am - 6:00 pm Sat: 8:00 am - 3:00 pm Sun Closed","TollFree: (888) 565-9629",,"all major credit cards, discover, amex, mastercard, visa, check, debit",,,http://www.guysandgalsquarters.com,"Parking: Free Wheelchair Accessible: Yes",,,,,,,,
266375,87445,"2020-09-27 02:38:24","Alter Ego",,asavantstyle@gmail.com,"(808) 334-1991","77-6425 Kuakini Hwy Ste D103","Kailua Kona",HI,96740,"77-6425 Kuakini Hwy Ste D103,Kailua Kona,HI 96740","Hair Stylists, Barbers, Beauty Salons, Bridal Shops, Day Spas, Massage Therapists, Nail Salons",,,,19.6047,-155.96233,,,,"Mon - Fri: 9:00 am - 5:00 pm Sat: 9:00 am - 4:00 pm Sun Closed",,,"debit, discover, check, mastercard, visa",,"Alter Ego Hair & Beauty",,"Specialties: Extensions, Asian Hair, Perms, Straight Perms, Curly Hair, Coloring, Kids' Hair Parking: Lot, Private Bike Parking: Yes Wheelchair Accessible: Yes Price Range : Average By Appointment Only: No",,,,,,,,
266638,87545,"2020-09-27 02:38:24","Amped Artistry",http://www.ampedartistry.com,giselle@ampedartistry.com,"(239) 404-8823","610 SW 99th AVE","Pembroke Pines",FL,33025,"610 SW 99th AVE,Pembroke Pines,FL 33025","Bridal Registries, Beauty Salons, Bridal Shops, Hair Stylists, Make-Up Artists",,,,26.00372,-80.27685,,,"Team of two beauty artists that provide professional hair and makeup services on location with over 8+ years each. Specializing in Airbrush Makeup. Available for Bridal, Print, TV, Fashion, Special FX and more!",,"Giselle Southeast FL Beauty Artist: (239) 404-8823 Christine Southwest FL Beauty Artist: (239) 991-0997",,"check, paypal, cash",,,"airbrush makeup artist",,,,,,,,,