United States
Resources
City Guides
JoinSign In
Cigna International Health Insurance
International Destination Report

11 Things to Know Before Moving to Annapolis, Maryland

By adminee

With its bustling downtown and beautiful waterfront dotted with yachts, sailboats and marinas, Annapolis, Maryland is a great city for expats who are working in the D.C./Baltimore area. Here are 10 things to know before moving to Annapolis, Maryland.

11-Things-to-Know-Before-Moving-to-Annapolis,-Maryland

Why People Like Living in Annapolis

With a population of close to 40,000, Annapolis, Maryland is a bustling city on the Chesapeake Bay that is conveniently located about an hour west of D.C. and an hour south of Baltimore.

Annapolis is home to the U.S. Naval Academy and St. John's College.

Downtown Annapolis is filled with restaurants, shops, old inns, a maritime museum and historical sites.

The city has numerous marinas and yacht clubs.

For families, Annapolis' Public Schools are well ranked plus there are a number of private schools in town.

Cost of Living

Cost of Living

A typical 3-4 bedroom home costs between $400-500,000. There are pricier homes, which run into the millions.

Apartments range in price. In a nice apartment complex with amenities a studio costs $1,500/month, a one bedroom costs $2,000/month and a three bedroom can go as high as $5,000.

Private schools range in cost. Tuition at St. Anne's K-8 runs from 1$7-20,000. The cost of the 5-day, 9am-3pm, pre-school program at St. Anne's runs from $13-17,000. Half-day and fewer day-a-week programs are less. At the Key School, tuition starts at $18,000 for a 5-day, 8:30-3 pre-school program and goes up to $29,000 for high school aged students.

Clubs & Volunteer Activities in Annapolis

The International Club of Annapolis is a great group for expats in Annapolis.

For moms, Moms Club of Annapolis and Greater Severna Park Mom's Club are great ways to connect with other moms (and kids).

Friends of the Lighthouse Shelter is a homeless prevention support center with 300+ volunteers. They host fundraisers such as the Bayside Bash, GumboFest and Taste of the Towne. Another place to volunteer is Gigi's Playhouse,a Down syndrome achievement center (part of a nationwide network).

Annapolis Schools

Annapolis Schools

Public schools include Annapolis High School, which has approximately 1,800 students; Private schools in the area include St. Anne's School (pre-K through 8th), Annapolis Area Christian School, St. Mary's Parish Elementary School, St. Martin's Lutheran School, Naval Area Primary School (military families) and the well-ranked Key School. The public school system offers a International Student and Family Welcome Center , English Language Acquisition program and the International Baccalaureate Program (IB).

Malls & Grocery Shopping in Annapolis

There are many grocery stores in Annapolis - Whole Foods, Sam's Club, Graul's Market, Giant, Shoppers, Fresh Market, Trader Joe's and Safeway. There are several Asian grocery stores in nearby Bowie, MD.

Annapolis Towne Center is an outdoor shopping center with clothing stores like Anthropologie, lululemon and Talbots, restaurants and even the Whole Foods. Westfield Mall has furniture stores (Pottery Barn, Crate & Barrel), clothing stores, restaurants and an 11 cinema movie theater.

Public Transportation

Public Transportation

Annapolis' Circulator Bus provides free transportation for the city's four parking garages into downtown. There is also a bus schedule for Annapolis public bus system, which offers various routes in and around the city.

The water taxi is a fun way to get around the downtown area and over to Eastport.

Annapolis' Climate

Annapolis has a temperate climate with cold, snowy winters (snowfall amounts vary from year to year), beautiful spring and fall weather and humid, hot summer days.

Restaurants and Nightlife

Restaurants and Nightlife

Annapolis has too many restaurants to list. Here are a few favorites: Boatyard Bar & Grill, Chick & Ruth's deli, Flamant MD (Flemish/European) and Vin 909 (wine bar + food).

For nighlife, Rams Head on Stage has concerts and music events. 49 West Coffeehouse has local live music nightly with great food, coffee and drinks. Stan & Joe's is another bar with live music.

There are a number of wonderful art galleries in Annapolis, which hosts an annual art walk.

Hospitals & Healthcare

Anne Arundal Medical Center is located in Annapolis. This 425-bed hospital serves Anne Arundal region. They are recognized for emergency heart attack response and cancer care. Many specialists and primary care physicians also have offices in Annapolis.

Expat Health Insurance in United States

Expats interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

Recreational Activities in Annapolis

Recreational Activities in Annapolis

Water-based activities are very popular in Annapolis - sailing, yachting, kayaking, paddle boarding and more. Mears Marina is just across the bridge in Eastport, with tennis courts, a swimming pool and marina. There are many golf clubs nearby as well.

Everyone's a Navy Fan!

Navy Stadium

If you're going to be living in Annapolis, you might as well get on board and become a Navy Fan. Navy-Marine Corps Stadium hosts Navy football and lacrosse games, plus it's the home of the Chesapeake Bayhawks, Maryland's Major League Lacrosse team.

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in United States from our partner, Cigna Global Health.
Get a Quote

More about Annapolis

Guide to Living in Annapolis

Guide to Living in Annapolis

The Expat Guide to Living in Annapolis, United States.

Healthcare in United States

Healthcare in United States

Expats in the United States have to navigate one of the most expensive health systems in the world. However, when properly navigated, the quality of care is excellent when compared to the rest of the world.

Join our United States Expat Forum

Visit our United States Forum and talk with other expats who can offer you insight and tips about living in Annapolis, United States.

More about United States

2020-Expat-Exchange-Survey2020 Expat Exchange Survey

If you've lived abroad within the last 3 years, please share your insights in our 2020 Expat Exchange Survey. You'll be entered to win (1 of 10) $50 Amazon giftcards. We need YOUR input... Take the Survey Now!

Healthcare-in-the-USHealthcare in the US

Expats in the United States have to navigate one of the most expensive health systems in the world. However, when properly navigated, the quality of care is excellent when compared to the rest of the world.

Cost-of-Living-in-New-York-CityCost of Living in New York City

New York City is one of the most "international" cities in the world, but expats there also contend with one of the most expensive costs of living at the same time. Here's what you need to know to get a general idea of what those costs are.

International-Schools-in-NYCInternational Schools in NYC

Expats living in NYC have many international and bilingual school choices -- international schools, bilingual schools, language immersion schools, IB World schools, British Schools and more. Here's a list of the most well-known international schools in NYC.

French-Schools-in-New-YorkFrench Schools in New York

Are you a Francophone moving to NYC? This article offers an extensive list of French schools in NYC with addresses, maps and accreditation information from the French Consulate General. The list covers all ages ranges from French nursery schools through French high schools in New York City. In addition to private French schools in the NYC area, this article covers all of the NYC public schools with French dual language programs (DLP) and several well-known French schools in suburban New York and New Jersey.

Comments & Questions

Sign In or Sign Up to reply

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in United States from our partner, Cigna Global Health.
Get a Quote

Healthcare in United StatesHealthcare in United States

Expats in the United States have to navigate one of the most expensive health systems in the world. However, when properly navigated, the quality of care is excellent when compared to the rest of the world.

Restaurants in AnnapolisRestaurants in Annapolis

Support your favorite restaurants in Annapolis as they recover from the pandemic. Submit a free listing for them on Expat Exchange to help spread the word about them to the expat community.

11 Things to Know Before Moving to Annapolis, Maryland11 Things to Know Before Moving to Annapolis, Maryland in Annapolis

With its bustling downtown and beautiful waterfront dotted with yachts, sailboats and marinas, Annapolis, Maryland is a great city for expats who are working in the D.C./Baltimore area. Here are 10 things to know before moving to Annapolis, Maryland.

2020-Expat-Exchange-Survey2020 Expat Exchange Survey

If you've lived abroad within the last 3 years, please share your insights in our 2020 Expat Exchange Survey. You'll be entered to win (1 of 10) $50 Amazon giftcards. We need YOUR input... Take the Survey Now!

Healthcare-in-the-USHealthcare in the US

Expats in the United States have to navigate one of the most expensive health systems in the world. However, when properly navigated, the quality of care is excellent when compared to the rest of the world.

Cost-of-Living-in-New-York-CityCost of Living in New York City

New York City is one of the most "international" cities in the world, but expats there also contend with one of the most expensive costs of living at the same time. Here's what you need to know to get a general idea of what those costs are.

International-Schools-in-NYCInternational Schools in NYC

Expats living in NYC have many international and bilingual school choices -- international schools, bilingual schools, language immersion schools, IB World schools, British Schools and more. Here's a list of the most well-known international schools in NYC.

United States Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /eetr/tip.cfm
Time Stamp 16-Jul-20 12:03 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.227
Host Name 172.69.63.227


Execution Time

Total Time Avg Time Count Template
383 ms 383 ms 1 /home/www/html/eetr/tip.cfm
285 ms 285 ms 1 /home/www/html/eetr/Application.cfm
98 ms 98 ms 1 /home/www/html/navtop_rdesign5.cfm
89 ms 89 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
79 ms 79 ms 1 /home/www/html/eetr/tiprentalproperty.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
24 ms 24 ms 1 /home/www/html/navcontentboxcitypc.cfm
24 ms 24 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
18 ms 18 ms 1 /home/www/html/navcontentboxcitytipmobile.cfm
6 ms 6 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
5 ms 5 ms 1 /home/www/html/eetr/navgettiplinkproperty.cfm
5 ms 5 ms 1 /home/www/html/eetr/rewritetipheadingstate.cfm
2 ms 2 ms 1 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 0 ms 9 /home/www/html/rewritearticle.cfm
1 ms 1 ms 1 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/constants.cfm
0 ms 0 ms 1 /home/www/html/eetr/datasources.cfm
0 ms 0 ms 3 /home/www/html/eetr/navconstants.cfm
0 ms 0 ms 2 /home/www/html/eetr/navinjection.cfm
0 ms 0 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navinjection.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
669 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/qry_GeneralSet.cfm @ 12:03:56.056
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=283ms, Records=1) in /home/www/html/eetr/Application.cfm @ 12:03:56.056
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportcityid (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 12:03:56.056
	Select citynetworkid2
	From allreports
	Where answerid = 79901 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 12:03:56.056
	Select *
	From citynetworks 
	Where citynetworkid = 8013 
GetNetworks (Datasource=tipripper, Time=0ms, Records=153, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=2ms, Records=19) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
	Select *
	From citynetworks
	Where networkID = 129
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 129 
getpropertycountries (Datasource=tipripper, Time=43ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks, sitecategories
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3
and allreports.hide <> 'y'

and allreports.tipcategoryid <> 2791

and allreports.tipcategoryid <> 2797
and allreports.networkid <> 159
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=32ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
SELECT * 
FROM sitecategories, qoptions, allreports
WHERE qoptions.qoid = sitecategories.tipcategoryid
and qoptions.parent = 0
and allreports.hide <> 'y'
and sitecategories.siteid = 3
and sitecategories.tipcategoryid <> 2791
and sitecategories.tipcategoryid <> 2797
and sitecategories.tipcategoryid <> ''
and sitecategories.tipcategoryid <> 2793
and sitecategories.tipcategoryid <> 2792
and allreports.tipcategoryid = sitecategories.tipcategoryid
group by sitecategories.tipcategoryid 
GetClassifieds (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, allreports.citynetworkid, allreports.citynetworkid2, sitecategories.categoryslug, allreports.statenetworkid, allreports.topicid, allreports.city, sitecategories.headingnav, allreports.topicid as topicid, allreports.state, allreports.rid
FROM allreports, sitecategories
WHERE allreports.answerid = 79901 
and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassified (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, Networks.networkid, Networks.shortname, Networks.networkname, citynetworks.shortname, allreports.citynetworkid, allreports.citynetworkid2, allreports.topicid as topicid, allreports.city, allreports.state, allreports.answerid, allreports.topicid 
FROM allreports, Networks, citynetworks
WHERE rid = 100
and allreports.answerid = 79901
and allreports.statenetworkid = Networks.networkid
and allreports.citynetworkid = citynetworks.citynetworkid
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
SELECT *
FROM topics

WHERE topicid = 11 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplinkproperty.cfm @ 12:03:56.056
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '129'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:03:56.056
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79901'
	and qid = 391
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
	SELECT DISTINCT hpimg as photo, fbimg
	FROM answers
	WHERE answerid = 79901 
getsummary (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
	SELECT DISTINCT summary
	FROM answers
	WHERE answerid = 79901 
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 79901 
	AND answerstext.qid = 83
	
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:03:56.056
	SELECT summary 
	FROM answers
	WHERE answerid = 79901 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:03:56.056
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-04-16"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 12:03:56.056
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-16 00:00:00.000"
and logtime < "2020-07-16 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 12:03:56.056
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-09"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:03:56.056
	SELECT *
	From contentcountcountry
	Where networkid = 129 
citycontentcheck (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:03:56.056
	SELECT *
	From contentcountcity
	Where citynetworkid = 8013 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 12:03:56.056
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-15"
    and fromDate < "2020-07-16"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:03:56.056
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getpropertycountries (Datasource=tipripper, Time=24ms, Records=130) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=2ms, Records=6) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
SELECT allreports.tipcategory, allreports.tipcategoryid, topicid
FROM allreports
WHERE rid = 100
AND allreports.networkid = 129
group by allreports.tipcategoryid 
CheckTrackings (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
  SELECT t.tpcid, tk.tpcid as tpcid, tk.trackingdate, tk.trackingtype, tk.trackingid, tk.dbname, tk.shared, tk.userid
  FROM commenttrackings tk, comments t 
  WHERE tk.tpcid = 79901
  and t.tpcid = 79901
  and tk.commenttype = 9
  AND tk.trackingtype = "S"
  AND tk.userid = "2"
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
SELECT *
FROM topics
WHERE topicid = 11 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 79901
	AND answerstext.qid = 391
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
SELECT userphoto, tipcount, username, aboutme 
FROM users
WHERE userid = 1 
GetUserProfile (Datasource=forum, Time=113ms, Records=1) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
  SELECT *
  FROM userprofiles
  WHERE userid = 1 
getbrief (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 79901
	AND answerstext.qid = 392
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
	SELECT DISTINCT hpimg as photo, tiplibraried, hpimg
	FROM answers
	WHERE answerid = 79901 
getcategory (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 79901
	AND answerstext.qid = 390
getmostpostsreply (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tip.cfm @ 12:03:57.057
  SELECT msgtext, m.msgdate as commentdate, msgid, userid
  FROM comments m 
  WHERE m.tpcid = 79901
  and m.commenttype = 9
  and m.isapproved = 1
  ORDER BY m.msgid DESC
getanswerstext (Datasource=tipripper, Time=4ms, Records=10) in /home/www/html/eetr/tiprentalproperty.cfm @ 12:03:57.057
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79901
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79901 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tiprentalproperty.cfm @ 12:03:57.057
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79901
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79901
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
checkifexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 12:03:57.057
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-07-15 12:03:57'}
and expertusers.enddate > {ts '2020-07-16 12:03:57'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=53ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 12:03:57.057
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-07-16 12:03:57'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tiprentalproperty.cfm @ 12:03:57.057
SELECT username
FROM users
WHERE userid = 1 
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 12:03:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 95
and answers.reviewed = 'y'
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 12:03:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 96
and answers.reviewed = 'y'
and answerstext.answerid = answers.answerid
 
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 12:03:57.057
	SELECT *
	FROM markers
	WHERE answerid = '79901'
	and lat <> ''
	and lng <> ''
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:03:57.057
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:03:57.057
	Select *
	From Networks
	Where networkid = 129 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:03:57.057
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:03:57.057
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 129
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-15"
and headerparagraphstart < "2020-07-16"
and headerparagraphstatus = 'live'

and headerparagraphweight = 'high'
gettaxgeneral2 (Datasource=expert, Time=3ms, Records=0) in /home/www/html/navcontentboxcitytipmobile.cfm @ 12:03:57.057
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 8013
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-16" 
    ORDER by articles.articleID desc  
getguidesummary (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navcontentboxcitytipmobile.cfm @ 12:03:57.057
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 8013
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitytipmobile.cfm @ 12:03:57.057
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 129 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/navcontentboxcitytipmobile.cfm @ 12:03:57.057
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 129
and allreports.networkid = 129
 and allreports.citynetworkid2 =  8013
and allreports.topicid = 11
and hide <> 'y'
 and allreports.answerid <> '79901'
order by allreports.answerid DESC
gettaxgeneral (Datasource=expert, Time=5ms, Records=5) in /home/www/html/rspnet_ctygd_readnext.cfm @ 12:03:57.057
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 129 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and publishdate < "2020-07-16"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
getbrief (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
	SELECT summary
	FROM answers
	WHERE answers.answerid = ''
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = ''
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79901 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 129 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 129
and allreports.networkid = 129
 and allreports.citynetworkid2 =  8013
and allreports.topicid = 11
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 11 
getanswerstext (Datasource=tipripper, Time=4ms, Records=10) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79901
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79901 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79901'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79901'
	and qid = 391
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79901 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:03:57.057
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '129'


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/eetr/tip.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/eetr/tip.cfm
QUERY_STRING=answerid=79901&networkid=129&topicid=11&slug=us&slug2=11-Things-to-Know-Before-Moving-to-Annapolis-Maryland
REMOTE_ADDR=172.69.63.227
REMOTE_HOST=172.69.63.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tip.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=32007865
cftoken=96553613
hitcount=1
lastvisit={ts '2020-07-16 12:03:56'}
timecreated={ts '2020-07-16 12:03:56'}
urltoken=CFID=32007865&CFTOKEN=96553613
Cookie Variables:
CFID=32007865
CFTOKEN=96553613
Session Variables:
cfid=32007865
cftoken=96553613
sessionid=IBEXPATEXCHANGE_32007865_96553613
urltoken=CFID=32007865&CFTOKEN=96553613
URL Parameters:
answerid=79901
networkid=129
slug=us
slug2=11-Things-to-Know-Before-Moving-to-Annapolis-Maryland
topicid=11
Debug Rendering Time: 12 ms