query
RESULTSET
query
  ACCESS ACCOUNTING ACCOUNTS ADDAGENTLINE ADWRITER ALLOWBANNERS ALLOWNEWUSER ASSOCIATEPUBID ATTACHFPOS ATTACHNEWPHOTOS BROCHURE_HEAD CAPTIONBGCOLOR CAPTIONFONTCOLOR CITY CLONEID COMPANY_NAME COMPANY_WEBSITE CONDO CONTACT_EMAIL CONTACT_NAME CONTACT_PHONE COPYLENGTH COVERIMAGE CREDITCARD DATAFEED DATAFEED DATEBARFONTCOLOR DATE_SIGNED_P DEADLINECOUNT DELETED DESCRIPTION DESCRIPTOR DIGITAL_EDITION_URL DIRECTORY_NAME DISCLAIMER_P DISCOUNT EMAIL1 EMAIL2 ENORMO ENTITY_TYPE EREADERS FAX FAX FEATURE30 FEATURE7 FEEDCOST FHA_WARN FPAGE_BW FPAGE_BW2 FPAGE_COL FPAGE_COL2 FPAGE_SPOT FPAGE_SPOT2 FREE_ISSUE FREQUENCY FWD_VTOUR GOOGLEBASE GOOGLE_ANALYTICS_CODE GRAPHICS_EMAIL HARMON HEADERBG HEADINGS HOMESCAPE HPAGE_BW HPAGE_BW2 HPAGE_COL HPAGE_COL2 HPAGE_SPOT HPAGE_SPOT2 ID ID INVOICE_MESSAGE IVRPHONE IVR_COUNT IVR_FONT IVR_POSITION IVR_SIGN LANDWATCH LASTACTIVITY LASTSESSION LIMITCOPY LINKSTYLE LISTINGS LOGIN LOGIN_NOTIFY LOGOAREABG LOGOAREAFONTCOLOR LOGO_HEIGHT LOGO_SIZE LOGO_WIDTH MAGAZINEID MAGAZINEID MAGCOLOR MAGDIRECTORY MAGZIP MAG_LOGO MAILPASSWORD MAPICON MAPICON_SHADOW MARKET_AREA MARKET_STATE MARQUEE MARQUEEID MASTERTITLE MAXMONTHLY MAXPERPAGE MAXPHOTOS MEMBERNOTES MEMO MENUFONT MENUSTYLE MERCH_ID MERCH_PIN MLSCHARGE MLSID MLSIDLINK MLS_IMPORT MONTHLYRATE NAMESTYLE NAREP NEW NEWLISTINGS NEWRATE NOTES NOTES NYTIMES OLD OLDLISTINGS OLDRATE ONLINECHARGE ONLINEONLYPLAN OODLE OPENHOUSES OPENHOUSE_BROKERID OPTION1 OPTION10 OPTION2 OPTION3 OPTION4 OPTION5 OPTION6 OPTION7 OPTION8 OPTION9 OVERSTOCK PAD4PAD PAGECOLOR PASSWORD PAYMENT_TERMS PAYPAL PAYPAL_EMAIL PHONE PHONE1 PHONE2 PHONETIC_MAGTITLE PHOTO_SVC PIN POBOX PREMIUM1 PREMIUM2 PREMIUM3 PREMIUM4 PROOFDEADLINE PROOFEXP PROOFHEADER PROOFMESSAGE PROOFS PROOFSIG PUBLISHERID PUBLISHERID PUBLISHER_NAME QPAGE_BW QPAGE_BW2 QPAGE_COL QPAGE_COL2 QPAGE_SPOT QPAGE_SPOT2 QRCODEPREF QRCODES QR_ACTION REFERRALS REQUIREADSIZE REQUIREMLS RUNLENGTH SAVEADS SELLERMESSAGE SENDCORRECTIONSBUT SESSIONS SHOWBANNERS SHOWCONTACTINFO SHOWHEADER SIDEBANNERS SIGNATURE_P SITEVISITOREMAILS SIZE SLOGAN SMSPHONE SMS_COUNT STATE STREET SUBHEADS SUBMITADS TECH TITLE TITLES TOURBANNERS TRAFFICREPORTS TRULIA VIRTUAL VTOUR_MUSIC WEBSITE WSJ WSJ_COUNT WSJ_MAXLISTINGS WSJ_MINLISTINGS WSJ_SHARE XALIAS XDEADLINE_NOTES XDOMAIN YAHOO ZILLOW ZIP ZOOM
1 5 eddinger123@charter.net 45 0 1 1 2 [empty string] 0 0 1 [empty string] [empty string] Lake Arrowhead [empty string] Resort Homes Magazine inc [empty string] 0 resorthomesmag@mac.com Greg Eddinger 909 336 2277 300 [empty string] 0 1 1 black 2010-05-02 10:06:36.0 1 [empty string] 8.5x11 Click here to find out more! [empty string] resorthomes 1 [empty string] resorthomesmag@mac.com eddinger123@charter.net 0 [empty string] 18 909 495 1490 909 495 1490 19.0000 7.0000 0.0000 1 0 0 595 595 0 0 0 1 0 <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-165820-22']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); </script> resorthomesmag@mac.com 0 PaleGoldenrod Goldenrod 0 0 0 320 295 0 0 466 466 We Appreciate Your Business! 866-978-1792 0 64,black 150,65 cellphonesign_usa_1792.jpg 0 2019-04-13 19:41:02.0 2019-04-13 19:41:02.0 0 5 157 resorthomes 1 black silver 126 51105 1022 570 570 [empty string] RESORT-HOMES-AND-REAL-ESTATE-for-Sale-in-Lake-Arrowhead-Running-Springs-Crestline 92352 MAGLOGO570_022709.jpg Jugut6As blue_tower.png greenhouse_shadow.png Lake Arrowhead Real Estate listings for sale in Crestline, Lake Gregory, Twin Peaks, Blue Jay,, Running Springs, Arrowbear, Green Valley Lake. Serving the MLS of Rim Of The World MLS and Mountain Lakes MLS. CA,AZ Realtors advertising in Resort Homes Magazine will show you all of the local listings for the Lake Arrowhead Real Estate communities including Crestline, Running Springs, Green Valley Lake, Lake Gregory, Arrowbear, Cedar Glen, Blue Jay Twin Peaks and Deer Lodge Park. 0 0 125 16 25 [empty string] [empty string] Black 1 [empty string] [empty string] 0 [empty string] [empty string] 1 125 1 1 23 0 0.5000 [empty string] [empty string] 500000 115 155 0.1000 24.99 0 0 0 36863 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0 0 white 2n34d Upon receipt 0 [empty string] 909-336-2277 909-336-2277 [empty string] 1 7603 P.O. Box 50 (PMB 349) [empty string] [empty string] [empty string] [empty string] CORRECTIONS MUST BE RECEIVED WITHIN 24 HOURS OF PROOF DELIVERY 5 [empty string] Please respond to this email with an Approved or Okay if this proof needs no corrections. 1 [empty string] 214 214 Gregory C Eddinger 0 0 200 195 0 0 [empty string] 1 [empty string] 1 1 0 0 0 1 1 3980 1 0 1 0 RHM 1 mag The First Place to find Your Second Home! 720.256.4661 0 CA Lake Arrowhead 0 1 [empty string] RESORT HOMES Lake Arrowhead Real Estate Listings For Sale 4 0 1 0 0 1 [empty string] 0.0000 78 9999 0 1 www.resorthomesmagazine.com narep lapsed 5-30-2015 www.ResortHomesMagazine.com 0 0 92352 15
CACHED false
EXECUTIONTIME 33
SQL SELECT MI.*,PI.*,RI.* FROM Magazine_Info MI, Publisher_Info PI, Rate_Info RI WHERE MI.PublisherID=214 AND PI.PublisherID=MI.PublisherID AND RI.magazineID=MI.magazineID and mi.magazineid <> '300' ORDER by MI.accounts desc, MI.MagazineID

PRICE REDUCED ...WAS $229,000.00

MLS: 2181703 | CITY: Lake Arrowhead
Single Family 2 BR | 2.00 BA | $208,900
502256 Updated: 13-Apr-19

LAKE ARROWHEAD AREA HOME FOR SALE 

Flat level entry. Self contained on main floor.2 bd. 2ba. with spa tub in lower bath. Walk in closet and laundry. 2 fireplaces for those chilly winter nights. New Granite counter tops in kitchen and new appliances just installed. Commuter friendly location as it is only about 2 minute drive to Highway 18. Walking distance to Tudor House. $208,900

Google(r) Share this listing on Facebook or Twitter Request More Info Send This Listing to A Friend

PRICE REDUCED ...WAS $2,995,000.00

MLS: 2180006 | CITY: Lake Arrowhead
Single Family 5 BR | 7.00 BA | $2,685,000
546624 Updated: 13-Apr-19

LAKE ARROWHEAD WATERFRONT PROPERTY FOR SALE 

Point Hamiltair Lakefront - First time on market - The many special features include; Inspiring lake views - Five bedroom suites - Level entry to garage & master suite - Whole house elevator - Open flowing entry with stone fireplace, dining & kitchen - Spacious family room & study w/ fireplace - Second expansive family room with fireplace, guest suite & kitchenette. 4 well-planned gardens - Street to lake native split granite infrastructure - Well located private deep water boat dock. Beautiful... $2,685,000.

Google(r) Share this listing on Facebook or Twitter Request More Info Send This Listing to A Friend

PRICE REDUCED ...WAS $2,975,000.00

MLS: 2180051 | CITY: Lake Arrowhead
Single Family 6 BR | 6.00 BA | $2,650,000
546656 Updated: 13-Apr-19

RAINBOW POINT LAKEFRONT HOME 

Impressive and Rare Contemporary Lakefront. Six Bedroom Remodel Spacious Luxury Home In Sought-after Rainbow Point. Some Of The Many Special Feature Include; Chef's Kitchen With All The Expected High-end Equipment - Family Room - Game Room - Fabulous Master Suite Along Upstairs At Street Level Offering No Steps From Street Level Two Car Garage -- Six Baths -- Workout Room -- Spa Room -- Large Lakeside Deck Leads To Private Single Slip Boat Dock. Exceptional! $2,650,000.

Google(r) Share this listing on Facebook or Twitter Request More Info Send This Listing to A Friend